Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting a discontinuous series
Excel XP 2002: I have 2 series of data. One has a value for every day of
the year. The second only has data points once per month. When I graph the 2 series, the second one (the one that only has 1 point per month) does not have a line connecting the values. I have tried all I know but can/t get the line to draw. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting a discontinuous series
Are there blank cells between data values? If so, select the chart, go to
Tools menu Options Chart tab, and choose the Interpolate method for dealing with blank cells. I presume you don't have a formula which returns "" in the hopes that Excel will think it signifies a blank cell (it doesn't). If you did you'd get markers along the Y=0 axis for these "" values (which are text, not blank), and a line connecting all points. If you change the "" in your formulas with NA(), you'd get a nice #N/A error, which suppresses plotting of a marker and draws a line connecting points on either side of the gap. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Branchola" wrote in message ... Excel XP 2002: I have 2 series of data. One has a value for every day of the year. The second only has data points once per month. When I graph the 2 series, the second one (the one that only has 1 point per month) does not have a line connecting the values. I have tried all I know but can/t get the line to draw. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time-Series Charting | Charts and Charting in Excel | |||
Discontinuous lines in series due to gaps in data points | Charts and Charting in Excel | |||
Charting Multiple Series? | Charts and Charting in Excel | |||
Charting series in different sheets (summarize) | Charts and Charting in Excel | |||
CHARTING W/INDIRECT SERIES | Charts and Charting in Excel |