Name
chart.ChartWizard([Source], [Gallery], [Format], [PlotBy], [CategoryLabels], [SeriesLabels], [HasLegend], [Title], [CategoryTitle], [ValueTitle], [ExtraTitle])
Synopsis
Quickly creates and formats a chart by setting the most commonly used properties and applying a best guess for omitted settings.
|
Argument |
Settings |
|---|---|
|
|
The |
|
|
A constant indicating the type of chart to create. Can be one of these settings: |
|
|
A number from 1 to 10 indicating the index of the chart subtype to create from the Chart Type dialog box. |
|
|
|
|
|
The number of rows or columns in the source range that contain category labels. |
|
|
The number of rows or columns in the source range that contain series labels. |
|
|
True creates a legend on the chart; False omits the legend. |
|
|
The caption to include as the title on the chart. Omitting this argument when creating a chart omits the chart title. |
|
|
The caption to include for the category axis (x-axis) on the chart. Omitting this argument when creating a chart omits the axis title. |
|
|
The caption to include for the value axis (y-axis) on the chart. Omitting this ... |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access