ChartSheet.ChartWizard Method

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assemblies:: Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Modifies the properties of the given ChartSheet.

public void ChartWizard (object Source, object Gallery, object Format, object PlotBy, object CategoryLabels, object SeriesLabels, object HasLegend, object Title, object CategoryTitle, object ValueTitle, object ExtraTitle);

abstract member ChartWizard : obj * obj * obj * obj * obj * obj * obj * obj * obj * obj * obj -> unit

Public Sub ChartWizard (Optional Source As Object, Optional Gallery As Object, Optional Format As Object, Optional PlotBy As Object, Optional CategoryLabels As Object, Optional SeriesLabels As Object, Optional HasLegend As Object, Optional Title As Object, Optional CategoryTitle As Object, Optional ValueTitle As Object, Optional ExtraTitle As Object)

Parameters

Source: Object

The range that contains the source data for the new chart. If this argument is omitted, Microsoft Office Excel edits the active chart sheet or the selected chart on the active worksheet.

Gallery: Object

The chart type.

Format: Object

The option number for the built-in autoformats. Can be a number from 1 through 10, depending on the gallery type. If this argument is omitted, Microsoft Office Excel chooses a default value based on the gallery type and data source.

PlotBy: Object

Specifies whether the data for each series is in rows or columns. Can be one of the following XlRowCol constants: xlRows or xlColumns.

CategoryLabels: Object

An integer specifying the number of rows or columns within the source range that contain category labels. Legal values are from 0 (zero) through one less than the maximum number of the corresponding categories or series.

SeriesLabels: Object

The number of rows or columns within the source range that contain series labels. Legal values are from 0 (zero) through one less than the maximum number of the corresponding categories or series.

HasLegend: Object

true to include a legend.

Title: Object

The chart title text.

CategoryTitle: Object

The category axis title text.

ValueTitle: Object

The value axis title text

ExtraTitle: Object

The series axis title for 3-D charts or the second value axis title for 2-D charts.

Examples

The following code example uses the ChartWizard method to set the data source and the chart type of the current Microsoft.Office.Tools.Excel.ChartSheet.

private void ModifyChartSheet()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.ChartWizard(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlChartType.xl3DColumn,false,
        "Revised chart");
}

Private Sub ModifyChartSheet()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.ChartWizard(Source:=Globals.Sheet1.Range("A1", "B5"), _
        Gallery:=Excel.XlChartType.xl3DColumn, _
        HasLegend:=False, Title:="Revised chart")
End Sub

Remarks

You can use this method to quickly format a Microsoft.Office.Tools.Excel.ChartSheet without setting all the individual properties. This method is non-interactive, and it changes only the specified properties.

If Source is omitted and either the selection is not an embedded chart on the active worksheet or the active sheet is not an existing chart, this method fails and an error occurs.

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Applies to

Share via