2 charts, same X axis
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!
Last edited by financialmonkey; 07-24-2009 at 07:28 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks