Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line and Point in the same chart?
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line and Point in the same chart?
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line and Point in the same chart?
Great, I really don't know how to thank you
- Rana "Jon Peltier" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
How to change color of line and point markers on a line graph | Charts and Charting in Excel | |||
how to produce horizontal line chart of point est & 95% ci's | Charts and Charting in Excel | |||
How do I get a value of a calculated point on an excel line chart? | Charts and Charting in Excel | |||
How to extend a single point into a line in a chart? | Charts and Charting in Excel |