| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Lines missing in line chart
I'm selecting the 4th sub-type under "Line Chart." The data points appear
but I want lines to connect the data points and lines do not appear. |
|
#2
|
|||
|
|||
|
are your cells with data contiguous?
when you double click on a data point on the chart, does the patterns window show lines? "Dave_lineless" wrote: I'm selecting the 4th sub-type under "Line Chart." The data points appear but I want lines to connect the data points and lines do not appear. |
|
#3
|
|||
|
|||
|
"bj" wrote: are your cells with data contiguous? when you double click on a data point on the chart, does the patterns window show lines? "Dave_lineless" wrote: I'm selecting the 4th sub-type under "Line Chart." The data points appear but I want lines to connect the data points and lines do not appear. BJ, 1) The cells containing data are NOT contiguous. 2) When I double-click the patterns window does show a line style. |
|
#4
|
|||
|
|||
|
try select your chart and <tools<options<Chart select plot empty cells as
interpolated "Dave_lineless" wrote: "bj" wrote: are your cells with data contiguous? when you double click on a data point on the chart, does the patterns window show lines? "Dave_lineless" wrote: I'm selecting the 4th sub-type under "Line Chart." The data points appear but I want lines to connect the data points and lines do not appear. BJ, 1) The cells containing data are NOT contiguous. 2) When I double-click the patterns window does show a line style. |
|
#5
|
|||
|
|||
|
Bingo. Worked like a charm. Thank you very much for your help.
"bj" wrote: try select your chart and <tools<options<Chart select plot empty cells as interpolated "Dave_lineless" wrote: "bj" wrote: are your cells with data contiguous? when you double click on a data point on the chart, does the patterns window show lines? "Dave_lineless" wrote: I'm selecting the 4th sub-type under "Line Chart." The data points appear but I want lines to connect the data points and lines do not appear. BJ, 1) The cells containing data are NOT contiguous. 2) When I double-click the patterns window does show a line style. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create vertical lines in a line chart? | Charts and Charting in Excel | |||
| Missing lines in chart w/x-axis with months 1-24... | Charts and Charting in Excel | |||
| Formatting lines between data points in a line chart | Charts and Charting in Excel | |||
| Lines not visible in an Excel line chart | Charts and Charting in Excel | |||
| Missing values in Excel Line Chart | Charts and Charting in Excel | |||
Hybrid Mode
