GALLERY.BAR

Macro Sheets Only

Equivalent to choosing a Bar template from the AutoFormat dialog box when a chart is active. Changes the format of the active chart to a bar chart.

Syntax

GALLERY.BAR(type_num, delete_overlay)
GALLERY.BAR?(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 bar 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