Excel Charts - Value Y axis scale - locking values to preventchanging

Hi,

Double click the axis and on the scale tab uncheck the Auto option for
Min/Max values

Cheers
Andy

yeagerr wrote:

Can someone tell me if there is a way to prevent the values on the Y
axis of a chart from changing when new data is added to the series? I
have 3 charts on a worksheet that are linked to external data. I would
like the Y axis values to remain constant but when the external data is
updated, the Y axis values change.


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


--

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