| | You will only be able to change these settings if you currently have a chart active. | |
| | Plot empty cells as - There are three choices: “Not Plotted” which ignores any blank cells and leaves gaps in the line: “Zero” which means blank cells are treated as zero, so the line drops to the zero-scale: “Interpolated” which means that any blank cells will have a connecting line meaning there are no gaps. | |
| | Plot visible cells only - If ticked will only plot visible cells and any hidden cells will not be plotted. | |
| | Chart sizes with window frame - This is only appropriate for charts on separate chart sheets, not for embedded charts. This will ensure the chart always fills the window. | |
