Value Axis Scale Change Problem

Hi there,

I currently have a line chart displaying trends over time.

The problem I have is that the chart appearance becomes meaningless
after updating the source data cell range.

This is because the minimum value for the Y axis changes from 2.2 to 0,
which in turn makes it difficult to detect trends over time.

I want to automatically adjust the scale to the value range, and have
set the chart up this way, but it is also causing the problem.

Please take a look at the attached .doc file for some screenshots of
the chart.

Why is it setting the minimum value to 0 and how can I get around this
whilst keeping the scale automation functionality?


+-------------------------------------------------------------------+
|Filename: Value Axis Scale Change Problem.doc |
|Download: http://www.excelforum.com/attachment.php?postid=2725 |
+-------------------------------------------------------------------+

--
dp_fulcher
------------------------------------------------------------------------
dp_fulcher's Profile: http://www.excelforum.com/member.php...fo&userid=9699
View this thread: http://www.excelforum.com/showthread...hreadid=270335

If the range between the minimum and maximum data exceeds 1/6 of the absolute value
of the maximum, Excel in its wisdom decides you need the full extent of the Y axis
to view it.

If you don't mind a little VBA, you can write your own worksheet formulas to select
axis scale parameters, and link your axis to these. I have an example here, with a
link to an automated solution by Tushar Mehta:

http://peltiertech.com/Excel/Charts/...nkToSheet.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

dp_fulcher wrote:

Hi there,

I currently have a line chart displaying trends over time.

The problem I have is that the chart appearance becomes meaningless
after updating the source data cell range.

This is because the minimum value for the Y axis changes from 2.2 to 0,
which in turn makes it difficult to detect trends over time.

I want to automatically adjust the scale to the value range, and have
set the chart up this way, but it is also causing the problem.

Please take a look at the attached .doc file for some screenshots of
the chart.

Why is it setting the minimum value to 0 and how can I get around this
whilst keeping the scale automation functionality?


+-------------------------------------------------------------------+
|Filename: Value Axis Scale Change Problem.doc |
|Download: http://www.excelforum.com/attachment.php?postid=2725 |
+-------------------------------------------------------------------+