Overlay two charts with the same axis

[MrLookout9]

Thank you for your time and expertise.

I am trying to do with with VBA but if there is an easier approach, I am all ears!

I have two charts(one X Y Scatter, one Stock) that have the same X and Y axis. As it stands now, I have them overlapped perfectly, manually.

As the data changes, the size of each chart changes, throwing off scale.

Excel & PowerPoint 2010

A) Is there a way to combine these into one chart?
B) If not, is there a way to set the scale and size of the axis to keep them aligned?

Thank you!

 

[Marmaduke_88]

I don't believe it's possible to combine the two charts into one single chart, beyond what you've already done manually.

To prevent the "size" of the chart from changing:

Right-click each chart axes individually and click "Format Axis". Under Axis Options, change the Minimum and Maximum from "Auto" to "Fixed", and enter the ranges you need.

Please note that you need to manually update both charts if your data changes to include numbers outside of your min/max ranges, else the charts will not display properly. Additionally, both chart ranges need to be identical otherwise the data will not display in accurate relation.

 

[Marmaduke_88]

I just realized I misread your post - it is possible to have both sets of data in one chart if they are the same chart type.

To do this, Format Data Series and under Series Options click the radio button to "Plot Series On" the Primary/Secondary axis.