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 |