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
|
|||
|
|||
Change display units to different sizes
There are ways to simulate the effect. See the 'Broken y axis' page of
my web site. However, what you are doing is probably much more efficient. You can format the two charts to look like one. Adapt the ideas on the 'Stacked Charts' page of my web site. -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , beeawwb says... Good morning all. I'm trying to get a chart with 6 series' to display over a different scale on the X axis, over different values. To be more clear (I'm not even sure how to say it) I have the values plotted between 0 and 650 (automatic). However, only 2 series have values higher than 200. What I currently do is, have 2 identical charts, but change the display values to 0-200 and 200-Automatic. Is there anyway to make the first half of a chart display 0-200,and the second half display 200-Automatic maximum? Thanks for any help you can provide. -Bob --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|