Line Graph trendlines in correct representation

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

In article ,
says...
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

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

In article ,
says...
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

.

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

In article ,
says...
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

In article ,
says...
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

.