Hidden and Empty

These settings only apply to the active chart and applies to all the series on the chart
All the series must have the same cell settings

This dialog box can be accessed from the Select Data Source dialog box.
Office Article - Display hidden worksheet data and empty cells in a chart, Interpolating missing values - KB 214096

This settings only applies to some of the chart types:
Line, XY Scatter and Radar charts
For all other chart types, missing data is simply not plotted - CHECK THIS

You can force Excel to interpolate by putting =NA() in the necessary cells ?

Plot Visible Only

Usually Excel doesn't plot data that is in hidden rows or columns
To override this remove the checkmark from this option
This setting is chart specific

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext