Defining scale on y axis
 

Hi there,
I have a simple, single line chart. The X axis has 4 values which are the
same as the data points i.e. 0, 9, 14, 21
The Y axis data is 0,13,17,25
The Y axis defaults to 0 - 30 in intervals of 5.
Is there some way to force the Y axis to show lines and intervals like the
data, i.e. at 0,13,17,25?

Thanks!

Defining scale on y axis
 

Hi Sarah,

One way is to use some dummy series to create the lines yourself.
After you have created the lines you can turn off both the Yaxis values
and the Yaxis gridlines. Click on this link to find out more.
http://peltiertech.com/Excel/Charts/...s.html#AddLine

HTH
Martin