Value Y axis - Not to start from zero

  • Thread starter Thread starter Code Numpty
  • Start date Start date
C

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?
 
Back
Top