OPTIONS.CHART

Macro Sheets Only

Equivalent to choosing the Options command from the Tools menu and then selecting the Chart Tab in the Options dialog box when a chart is activated for editing. Sets various chart settings.

Syntax

OPTIONS.CHART(Display_Blanks, Plot_Visible, Size_With_Window)
OPTIONS.CHART?( Display_Blanks, Plot_Visible, Size_With_Window)

Display_Blanks is a number indicating how blank cells are plotted.

Number Blanks are displayed as

1 Not plotted (gaps are shown)

2 Zero values

3 interpolated

Plot_Visible is a logical value that if TRUE plots only visible data. If FALSE, all cells in the selection are plotted.

Size_With_Window is a logical value that if TRUE allows the chart to resize with window. If FALSE, chart will not size with window.

Remarks

If any of the arguments are omitted, then that setting is unchanged within the Options dialog box.

Related Functions

PREFERRED Changes the format of the active chart

SET.PREFERRED Changes the default chart format

List of Command-Equivalent Functions