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
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext