If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Two Charts On One
Is it possible to show two charts on one; similar to a
stock chart showing both the price on top with the corresponding volume on the bottom? I know how to do the two axies thing, but the scaling gets goofed up. I can do two separate charts which sit atop one another but that doesn't look good. Any Ideas? Thanks Jim |
#2
|
|||
|
|||
Jim -
I've done this both ways. Putting it into a single chart requires a lot of work setting up the axes, but you can use http://peltiertech.com/Excel/Charts/ArbitraryAxis.html to fudge your compound axis, and http://peltiertech.com/Excel/Charts/...Gridlines.html or http://peltiertech.com/Excel/Charts/AddLine.html to add a line separating top and bottom parts. Doing it with two charts is less work setting up the separate parts, but much more work assuring that the time scales of the two charts are synchronized. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Jim wrote: Is it possible to show two charts on one; similar to a stock chart showing both the price on top with the corresponding volume on the bottom? I know how to do the two axies thing, but the scaling gets goofed up. I can do two separate charts which sit atop one another but that doesn't look good. Any Ideas? Thanks Jim |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to Make Pie Charts the Same Size | Jon Peltier | Charts and Charting | 0 | May 3rd, 2004 09:34 PM |
Distribute dynamically charts with linked data as stand-alone charts | Richard | Charts and Charting | 2 | March 31st, 2004 05:16 PM |
charts inadvertly resized | Hammer_757 | Charts and Charting | 0 | March 24th, 2004 02:16 AM |
printing multiple charts per page | Pablo | Charts and Charting | 1 | February 27th, 2004 05:37 PM |
Creating a large number of charts automatically (repost) | Francine Kubaka | Charts and Charting | 0 | September 21st, 2003 09:16 PM |