| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Lines Between Data Points
I constructed a simple line chart but there are no lines connecting the data
points. I tried Format Data/Line and it showed that there was supposed to be a line connecting the data points. What should I check next? Thanks in advance. -- al |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Missing Lines Between Data Points
I'd check both the color of the line (may be white) and the width of the line
(may be too small to see. "al" wrote: I constructed a simple line chart but there are no lines connecting the data points. I tried Format Data/Line and it showed that there was supposed to be a line connecting the data points. What should I check next? Thanks in advance. -- al |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Missing Lines Between Data Points
Go to tools-option-chart and select 'plot empty cells as interpolated'
"Bob Umlas, Excel MVP" wrote: I'd check both the color of the line (may be white) and the width of the line (may be too small to see. "al" wrote: I constructed a simple line chart but there are no lines connecting the data points. I tried Format Data/Line and it showed that there was supposed to be a line connecting the data points. What should I check next? Thanks in advance. -- al |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to draw trend lines through only certain data points | Charts and Charting in Excel | |||
| missing data points causes my line graph not to connect | Charts and Charting in Excel | |||
| Line charts with missing data points in Excel 2007 | Charts and Charting in Excel | |||
| How do I chart missing data points in a scatter graph? | Charts and Charting in Excel | |||
| interpolate missing data between points | Excel Worksheet Functions | |||
Linear Mode
