Peltier Technical Services, Inc.
- Custom Excel Solutions

PTS Blog: Charts and Things

Jon's Excel and Charting Pages
- Jon's Charts - Tutorials - Excel
- Site Index and Search - RSS

Align Excel Charts Using VBA

Align One Chart Atop Another.

This zipped workbook contains the code that aligns Chart 2 on top of Chart 1, then erases everything out of Chart 2, except for the plotted series. Originally the charts look like this:

But running the code will turn them into this:

There is not a lot of documentation, but also not a lot of code to wade through. It seems to work pretty well on line and column charts. Sometimes the axis scale parameters don't "take" the first time, so the macro must be run twice. This is not uncommon in chart formatting macros, believe it or not.

This kind of effect can usually be done with combination charts, but it is an interesting exercise in the Excel charting object model.

Peltier Technical Services, Inc.
We can customize or automate any example from this site, or build a new one for you. To discuss your project or obtain a quote, please contact me at jonxlmvp@peltiertech.com

PTS Blog: Charts and Things

Jon's Excel and Charting Pages
- Jon's Charts - Tutorials - Excel - Site Index and Search - RSS

Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.

Microsoft Most Valuable Professional

My MVP Profile