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 |
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 |
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 |
All times are GMT +1. The time now is 06:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com