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