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

--
Message posted from http://www.ExcelForum.com

Hi Keith,

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

Cheers
Andy

keith0628 < wrote:

> I have created a line chart that have three different number ranges
> associated with it. Two of the three groups are close to each other
> (the numbers are between 5000 and 8000), but the third group is
> significantly higher (between 180000 and 230000). So my graph barely
> shows the first two groups at the bottom of the chart. I would like to
> take out of the graph the range 25,000 to 175,000 to show more of the
> detail for the first two groups.
>
> Can this be done?
>
> Thanks,
>
> Keith
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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/
_______

keith0628 < wrote:
> I have created a line chart that have three different number ranges
> associated with it. Two of the three groups are close to each other
> (the numbers are between 5000 and 8000), but the third group is
> significantly higher (between 180000 and 230000). So my graph barely
> shows the first two groups at the bottom of the chart. I would like to
> take out of the graph the range 25,000 to 175,000 to show more of the
> detail for the first two groups.
>
> Can this be done?
>
> Thanks,
>
> Keith
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>