Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Development Tools and Languages
Visual Studio 2012
Office Development in Visual Studio
Create Add-ins and Customizations for Office by using Visual Studio
Managed Reference (Office Development in Visual Studio)
Microsoft.Office.Tools.Excel
ChartSheetBase Class
ChartSheetBase Methods
Activate Method
ApplyChartTemplate Method
ApplyCustomType Method
ApplyDataLabels Method
ApplyLayout Method
Arcs Method
AreaGroups Method
AutoFormat Method
Axes Method
BarGroups Method
BeginInit Method
EntryPoint.BeginInit Method
Buttons Method
ChartGroups Method
ChartObjects Method
ChartWizard Method
CheckBoxes Method
CheckSpelling Method
ClearToMatchStyle Method
ColumnGroups Method
Copy Method
CopyChartBuild Method
CopyPicture Method
CreatePublisher Method
Delete Method
Deselect Method
Dispose Method
DoughnutGroups Method
DrawingObjects Method
Drawings Method
DropDowns Method
EndInit Method
EntryPoint.EndInit Method
Evaluate Method
Export Method
ExportAsFixedFormat Method
FinishInitialization Method
EntryPoint.FinishInitialization Method
get_HasAxis Method
GetAutomationObject Method
IChartSheetExtension.GetAutomationObject Method
GetChartElement Method
GroupBoxes Method
GroupObjects Method
Initialize Method
EntryPoint.Initialize Method
InitializeDataBindings Method
EntryPoint.InitializeDataBindings Method
Labels Method
LineGroups Method
Lines Method
ListBoxes Method
Location Method
Move Method
OLEObjects Method
EntryPoint.OnShutdown Method
OnShutdown Method
EntryPoint.OnStartup Method
OnStartup Method
OptionButtons Method
Ovals Method
Paste Method
Pictures Method
PieGroups Method
PrintOut Method
PrintOutEx Method
PrintPreview Method
Protect Method
RadarGroups Method
Rectangles Method
Refresh Method
SaveAs Method
SaveChartTemplate Method
ScrollBars Method
Select Method
SeriesCollection Method
set_HasAxis Method
SetBackgroundPicture Method
SetDefaultChart Method
SetElement Method
SetSourceData Method
Spinners Method
TextBoxes Method
Unprotect Method
XYGroups Method
Expand Minimize
This topic has not yet been rated - Rate this topic

ChartSheetBase.ApplyCustomType Method

Visual Studio 2012

Applies a standard or custom chart type to a Microsoft.Office.Tools.Excel.ChartSheetBase.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
C#
VB
Copy 
public void ApplyCustomType(
	XlChartType chartType,
	Object typeName
)

Parameters

chartType
Type: XlChartType

A standard chart type.

typeName
Type: Object

The name of the custom chart type if ChartType specifies a custom chart gallery.

Optional Parameters

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

The following code example uses the ApplyCustomType method to set the current Microsoft.Office.Tools.Excel.ChartSheetBase to a standard chart type that uses clustered bars to display data.

C#
VB
Copy 
private void SetChartSheetType()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ApplyCustomType(Excel.XlChartType.xlBarClustered);
}
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.