ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How, on a line chart, to skip blank entry rather than plot as 0? (https://www.excelbanter.com/charts-charting-excel/98991-how-line-chart-skip-blank-entry-rather-than-plot-0-a.html)

JohnTerp

How, on a line chart, to skip blank entry rather than plot as 0?
 
How, on a line chart, to skip blank entry rather than plot as 0?

Keylay31

How, on a line chart, to skip blank entry rather than plot as 0?
 
Select the chart, go to tools, options, chart, and select interpolated. This
option should be avaliable for most chart types, though I've noticed its not
for scatter.

"JohnTerp" wrote:

How, on a line chart, to skip blank entry rather than plot as 0?



All times are GMT +1. The time now is 02:14 AM.

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