|
The Active Chart section (below) applies
only to a pre-selected chart, (if embedded on a
sheet) or the active chart sheet.
Plot empty
cells as: has three settings, leave gaps
which ignores the data if blank, treats it as
zero and plots it to that or, in the case of
line charts only, connects the lines as if
the data didn't exist (Interpolated). If you
want to ignore the data and also have no gaps
incorporate the NA() function into your data or
chart source.
Plot
visible cells only allows you to ignore
hidden cells when creating a chart. (default is
checked).
Chart sizes with widow frame only
applies to chart sheets. Un-checking this allows
you to size the chart irrespective of the window
size.
The Chart tips
section controls what 'tooltips' are shown when
you hover over chart components. 'Show names'
will show object names, e.g. 'gridlines', etc,
whereas 'Show values' will show the underlying
values of data points, (see below).
 |
