GALLERY.SCATTER

Macro Sheets Only

Equivalent to choosing an XY (Scatter) template from the AutoFormat dialog box when a chart is active. Changes the format of the active chart to an xy (scatter) chart.

Syntax

GALLERY.SCATTER(type_num, delete_overlay)
GALLERY.SCATTER?(type_num, delete_overlay)

Type_num is the number of a format in the AutoFormat dialog box when a chart is active dialog box that you want to apply to the xy (scatter) chart.

Delete_overlay is a logical value specifying whether to delete an overlay chart.

• If delete_overlay is TRUE, Microsoft Excel deletes all overlays, if present, and applies the new format to the main chart.
• If delete_overlay is FALSE or omitted, Microsoft Excel applies the new format to either the main chart or the overlay, depending on the location of the selected series.

Related Functions

List of Command-Equivalent Functions