Line Chart Incorrect Data Display

  • Thread starter Thread starter Gingerly
  • Start date Start date
G

Gingerly

My data in the worksheet cell is '100%' - on the chart is plotting '118%'.
Please help. Thanks!
 
Hi,

Not a lot of information to go, but try checking the line chart is not of
the stacked variety.

Cheers
Andy
 
Hi Andy
Thanks so much for your quick response but I had read through the threads
and had already checked to see if it was a stacked linear chart. It was not.
I resolved the issue but probably not in the best way. When I clicked to
edit the Y axis, I saw that the maximum field was set to 1.2 so I just
uncheched that field and changed the value to 1.0 and it seemed to work.
 
Hi,

Not sure how setting the max to 100% has solved the problem. I think you
have just masked the problem by cutting the line so section above 100% is
not displayed. Of course the slope of the line will still be incorrect.

If you want to send example I will take a look.

andy AT andypope DOT info

Cheers
Andy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ChartArea.left reporting incorrectly? 4
Not plot a data series in a chart but still display in data table 1
Showing totals in data table in a line chart 3
Line and Bar on same chart 2
Excel 2007: Lines not displaying on Scatter Plots 1
Chart does not render plotted points correctly, data comes from a 3
X-Axis Units Disappear in Stacked Area Chart (Excel 2007) 0
Different data series in table than in the line chart 1

Back
Top