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/