axis break in chart

L

Lydia

In Excel 2002 I have a line chart with two data series. The Y-axis of one
data series is down around 200. The other series is up around 500,000. Is
there a way to make a break in the Y-axis so that there isn't a bunch of
room between the two data series? I can change the scale, but then it makes
the lines look flat and you can see the variation in data ups and downs.

Thanks,
Lydia
 
A

Andy Pope

Hi Lydia,

Have a look a Jon's example,
(http://peltiertech.com/Excel/Charts/BrokenYAxis.html)

It also contains links to example by Tushar Mehta and myself.
In Excel 2002 I have a line chart with two data series. The Y-axis of one
data series is down around 200. The other series is up around 500,000. Is
there a way to make a break in the Y-axis so that there isn't a bunch of
room between the two data series? I can change the scale, but then it makes
the lines look flat and you can see the variation in data ups and downs.

Thanks,
Lydia
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scatter charts for name with two values 0
simple chart 0
Trendline Not Appearing In Chart Problem ? 0
Excel chart does not start at zero. 1
setting scale on chart automatically 1
Bizarre chart behaviour when changing axis cross at points 2
Weird issue with very simple line chart - urgent 3
Pivot Charts 0

Top