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

K

Keylay31

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Timeline Plots 0
How to create a bubble chart with more than 2 variables. 0
Surpressing plot of blank cells 4
#N/A plotted as 0 on line chart 0
Employee Schedule not plotting properly - chart type / data series not correct 0
How do I plot "" as empty rather than zero in a chart 2
Bar and Line plots on the same chart 2
Values plotted incorrectly on Line Chart 3

Top