D
dp_fulcher
Hi there,
I currently have a line chart displaying trends over time.
The problem I have is that the chart appearance becomes meaningles
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 hav
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 o
the chart.
Why is it setting the minimum value to 0 and how can I get around thi
whilst keeping the scale automation functionality
+-------------------------------------------------------------------
|Filename: Value Axis Scale Change Problem.doc
|Download: http://www.excelforum.com/attachment.php?postid=2726
+-------------------------------------------------------------------
I currently have a line chart displaying trends over time.
The problem I have is that the chart appearance becomes meaningles
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 hav
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 o
the chart.
Why is it setting the minimum value to 0 and how can I get around thi
whilst keeping the scale automation functionality
+-------------------------------------------------------------------
|Filename: Value Axis Scale Change Problem.doc
|Download: http://www.excelforum.com/attachment.php?postid=2726
+-------------------------------------------------------------------