Selecting a range for your Y-axis

Originally Posted by tg06

Does anybody know how you can select a range of data that you want to use for the Y-axis of a chart?

Cheers

tg06

Hi,

did you mean asin rightmouse on the Gridlines, Format Gridlines and select Scale ?

---

Originally Posted by tg06

No, that way you have to manually type in the maximum and minimum values you want to see on the Y axis, but I have calculated some data in a worksheet that I want to use as the scale on the Y axis - so want to select that data for the chart to use for the Y-axis.

Hope that makes sense?!?!

You can select the data range for the x-axis but not for the y-axis! Not that I can find anyway! And thats what I want.

Yes, but the only way I could find to do that was to have the last entry in the series hidden and worth the maximum. This scaled the chart, but did leave one small gap on the right hand side, hardly noticeable on charts that have many datapoints and a between-datapoints gap

hth
---

that chart was http://www.excelforum.com/attachment...0&d=1164682375 a special purpose block chart, all datapoints having the same value (yes, we get weird requests).
---