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?

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Code Numpty" wrote in message
...
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?

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