Locking Multiple Charts Together

[Guest]

Is there a way to layer multiple charts, one on top of the other, so that
they all become one object to Excel? This way the charts could display
things that one chart can not currently do by itself. This would be similar
to CA-Tel-a-graf program does on a mainframe for creating a chart or graph.
Any ideas?

 

[Jon Peltier]

It's preferable to create combination charts to put all of the data into the same chart. This
means you won't have to align the axes and other features of the overlaid charts.

But it is possible to overlay charts. The top one should have its plot area and chart area made
transparent (no fill) to allow the underlying chart to show. I have a rudimentary program on my
site that does just this:

http://peltiertech.com/Excel/Charts/AlignCharts.html

There is precious little documentation and error checking. Use it on a copy of your charts,
until you're sure it does what you need.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______