You want Jan, Feb, and April to be on the same line, without March?
Rearrange your data as shown:
M L G Y M L G Y
Jan 5 7 8 2
Feb 4 7 1 4
Mar 8 4 4 9
Apr 3 5 7 1
Make eight series instead of four. Go to Tools menu Options Chart tab,
and choose the Interpolate option for how you want Excel to deal with gaps.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Rana" wrote in message
...
Hello,
I have data as follows:
M L G Y
Jan 5 7 8 2
Feb 4 7 1 4
Mar 8 4 4 9
Apr 3 5 7 1
I need to display the data using x = (Jan, Feb, Mar, Apr) and y = (M, L,
G,
Y) using a Line chart except for Mar which I wanted to appear as a
separate
point.
Do you have any idea, I appreciate your help