ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   I can't get the lines to connect on my line graph (https://www.excelbanter.com/charts-charting-excel/54439-i-cant-get-lines-connect-my-line-graph.html)

solesmate

I can't get the lines to connect on my line graph
 
I have a line graph and can see the points plotted but the lines are not
connected. What am I doing wrong?

Andy Pope

I can't get the lines to connect on my line graph
 
Hi,

Couple of things to check.
Do you have values for all the points on your line, that is no gaps in
your data. If you have empty cells select the chart and then check, via
the menu Tools Options, the chart tab settings for plotting empty cells.
Do you have a line style selected, as it is possible to plot points
without a joining line. Double click a point and check the Patterns tab
for formats being applied to the line.

Cheers
Andy

solesmate wrote:
I have a line graph and can see the points plotted but the lines are not
connected. What am I doing wrong?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 05:16 AM.

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