I have a dynamic chart, thus every month when I add new data, the chart
automatically updates. The problem I have is the Axis Range that Excel
automatically sets is way too big. I know I can fix the range, however as my
data changes the data may wander out of the range. Thus I would like to know
if I can set a dynamic range, like 100 below and above the min and max of the
data?

Any ideas?

Thank you,
Eli