Line Chart values appearing at wrong place

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have some values as below. The max scale is 10. But values for H, G are
showing at point 10, though the values are 2.4 & 0.3 etc. What is the problem.

Apr May Jun Jul Aug Sep
A 0.7 0.7 0.7 0.7 0.7 0.7
B 0.4 0.4 0.4 0.4 0.4 0.4
C 0.0 0.3 0.3 0.3 0.3 0.3
D 4.4 4.4 4.4 4.6 4.6 4.6
E 0.2 0.2 0.2 0.0 0.0 0.0
F 2.0 1.5 1.5 1.5 1.5 1.5
G 0.0 0.3 0.3 0.3 0.3 0.3
H 2.4 2.4 2.4 2.4 2.4 2.4
 
It seems to be working for me.
My data range is =Sheet1!$A$1:$G$9 and the series is organized in rows.
For each series the name is in column A and the values are in columns B
through G.
The Category (X) axis labels are in cells =Sheet1!$B$1:$G$1.
For my Value axis (Y) the scale is Minimum is auto and set at 0, Maximum is
manually set at 10, Major unit is automatically set at 1, Minor unit is
automatically set at .2, and category X axis crosses at is automatically set
at 0.
The line chart appears to be working well for me with the test data you
submitted. Perhaps check the source ranges or delete the chart and try
again. Based on your test data however 10 may be too high a maximum Y axis
value.

Hope that helps.
 
Back
Top