Adjusting the Y axis of a chart

[keith0628]

I have created a line chart that have three different number range
associated with it. Two of the three groups are close to each othe
(the numbers are between 5000 and 8000), but the third group i
significantly higher (between 180000 and 230000). So my graph barel
shows the first two groups at the bottom of the chart. I would like t
take out of the graph the range 25,000 to 175,000 to show more of th
detail for the first two groups.

Can this be done?

Thanks,

Keit

 

[Andy Pope]

Hi Keith,

Jon Peltier has a page describing this problem,
http://peltiertech.com/Excel/Charts/BrokenYAxis.html

Cheers
Andy

 

[Jon Peltier]

Keith -

You could plot the third series on the secondary axis (double click the
series, Axis tab, Secondary). Or if you're up for a little adventure,
try this technique on my web site:

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______