ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Missing Lines Between Data Points (https://www.excelbanter.com/excel-discussion-misc-queries/197484-missing-lines-between-data-points.html)

al

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

Bob Umlas, Excel MVP

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


jhaines

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



All times are GMT +1. The time now is 04:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com