Skip to content

Latest commit

 

History

History
45 lines (29 loc) · 901 Bytes

Excel.Application.Charts.md

File metadata and controls

45 lines (29 loc) · 901 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Application.Charts property (Excel)
vbaxl10.chm132085
vbaxl10.chm132085
Excel.Application.Charts
d60d912c-7c70-7004-d876-e83b98a13de9
04/04/2019
medium

Application.Charts property (Excel)

Returns a Sheets collection that represents all the chart sheets in the active workbook.

Syntax

expression.Charts

expression A variable that represents an Application object.

Example

This example sets the text for the title of Chart1.

With Charts("Chart1") 
 .HasTitle = True 
 .ChartTitle.Text = "First Quarter Sales" 
End With

This example hides Chart1, Chart3, and Chart5.

Charts(Array("Chart1", "Chart3", "Chart5")).Visible = False

[!includeSupport and feedback]