2 charts, same X axis

financialmonkey · #1 07-24-2009, 05:59 PM

Hey all,

Im trying to figure out how to create a chart like this:
http://4.bp.blogspot.com/_m3CQF7whYY...1600-h/spy.JPG

Same X axis value (time) in between but different values (Y Axis) in each panel.

If someone could point me in the right direction that would be sweeeeet!

Thanks!

Claymation · #2 07-24-2009, 08:52 PM

Plot both values on the same chart, then select one of the series and move that to the "secondary axis". Right click on a value in the series and go Selected Object > Axis > Secondary Axis (for 2003). The process will be similar for 2007, but I don't have a version in front of me to give the exact specifics.

From there they will share the same X-axis, but the Y-axis will be different.

Hope that helps.

Welcome to the Excel Forum

Forum Statistics