Line Graph trendlines in correct representation

  • Thread starter Thread starter sri
  • Start date Start date
S

sri

A Line Graph contains two trendlines of 2002, 2003 year
from 12 cells each.
It shows the correct data values, while the line placement
in the graph is not correct. For example, In May, the
2003 point of 9 is higher on the graph than the 2002 value
of 124. Could anybody tell me why it's happening

Thank you,
sri
 
You are probably using a Stacked Line chart. [In the list of Line
chart subtypes this is the row 1 column 2].

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Which one do I need to use to display the exact values.
Thank you for answer.
Thank you,
sri
-----Original Message-----
You are probably using a Stacked Line chart. [In the list of Line
chart subtypes this is the row 1 column 2].

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

A Line Graph contains two trendlines of 2002, 2003 year
from 12 cells each.
It shows the correct data values, while the line placement
in the graph is not correct. For example, In May, the
2003 point of 9 is higher on the graph than the 2002 value
of 124. Could anybody tell me why it's happening

Thank you,
sri
Click to expand...
.
Click to expand...
 
Try the different sub-types and see which represents the data in a
manner that you want. It will be a lot faster than my -- or anyone
else -- trying to guess what you will find useful.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Which one do I need to use to display the exact values.
Thank you for answer.
Thank you,
sri
-----Original Message-----
You are probably using a Stacked Line chart. [In the list of Line
chart subtypes this is the row 1 column 2].

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

A Line Graph contains two trendlines of 2002, 2003 year
from 12 cells each.
It shows the correct data values, while the line placement
in the graph is not correct. For example, In May, the
2003 point of 9 is higher on the graph than the 2002 value
of 124. Could anybody tell me why it's happening

Thank you,
sri
Click to expand...
.
Click to expand...
Click to expand...
 
Back
Top