Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Joining data points on a line chart
I have the following as an example set of data points to be plotted on either
a line or scatter chart (doesn't matter which as I am having the same problem with both!) X Y1 Y2 1 2 1.8 2 4 3 6 4.5 4 8 5 10 9 6 12 I get a line drawn between the points for Y1, but because there is not a Y2 value for every point on the X-axis then I just get points and no line, despite a line being selected for in the options! Does anyone know how to get this line added on? Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Joining data points on a line chart
In each empty cell enter =NA(); this will display as #N/A.
The line on chart will be continuous. OR Click chart; use Tools|Options; open Chart tab and look at "Plot empty cells as" best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "JCW173" wrote in message ... I have the following as an example set of data points to be plotted on either a line or scatter chart (doesn't matter which as I am having the same problem with both!) X Y1 Y2 1 2 1.8 2 4 3 6 4.5 4 8 5 10 9 6 12 I get a line drawn between the points for Y1, but because there is not a Y2 value for every point on the X-axis then I just get points and no line, despite a line being selected for in the options! Does anyone know how to get this line added on? Thanks |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Joining data points on a line chart
Hi,
Select the chart and from the menus Tools Options Chart. Plot Empty cells as Interpolated. Cheers Andy JCW173 wrote: I have the following as an example set of data points to be plotted on either a line or scatter chart (doesn't matter which as I am having the same problem with both!) X Y1 Y2 1 2 1.8 2 4 3 6 4.5 4 8 5 10 9 6 12 I get a line drawn between the points for Y1, but because there is not a Y2 value for every point on the X-axis then I just get points and no line, despite a line being selected for in the options! Does anyone know how to get this line added on? Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to add labels to data points in an xy scatter chart | Charts and Charting in Excel | |||
Data selection on line chart | Charts and Charting in Excel | |||
Fan charts | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |