Value Y axis - Not to start from zero

[Code Numpty]

I have a chart with 5 columns in the data range from (typically) the
following data. The data range is already set up in a template so the user
pastes in values to get the correct chart. Because the data changes with each
instance the source data can vary, hence some cells are empty.

0.2 0.0017497 0.0017397 0.001774494 0.001704906
0.4 0.0017613 0.0017397 0.001774494 0.001704906
0.6 0.0017538 0.0017397 0.001774494 0.001704906
0.8 0.0017459 0.0017397 0.001774494 0.001704906
1 0.0017397 0.0017397 0.001774494 0.001704906
1.2 0.0017358 0.0017397 0.001774494 0.001704906
1.6 0.0019809 0.0017397 0.001774494 0.001704906
2 0.0021619 0.0017397 0.001774494 0.001704906

Column A gives the category (x) axis labels.
Column B is plotted as series 1
Column C is plotted as series 2
Column D is plotted as series 3
Column E is plotted as series 4

My problem is that the Y axis runs from 0 to 0.0025, possibly because of the
blank cells?

What I would like to have is the Y axis show a scale from the minimum value
in columns B to E to the maximum value in columns B to E.

Is this possible?

 

[Andy Pope]

Hi,

Only way to have that amount of control over the scale properties is with
VBA
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

Cheers
Andy

 

[Code Numpty]

Thanks Andy, I'll follow your link and look into that.