Changes the format of the active chart to an area chart.
Syntax
GALLERY.AREA(type_num, delete_overlay)
GALLERY.AREA?(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 area 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.
Return to index