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 Properties
_CodeName Property
Application Property
Area3DGroup Property
AutoScaling Property
BackWall Property
Bar3DGroup Property
BarShape Property
Base Property
BindingContext Property
ChartArea Property
ChartStyle Property
ChartTitle Property
ChartType Property
CodeName Property
Column3DGroup Property
Corners Property
Creator Property
DataBindings Property
DataHost Property
DataTable Property
DepthPercent Property
DisplayBlanksAs Property
Dummy24 Property
Dummy25 Property
Elevation Property
IExtension.ExtensionBase Property
Floor Property
GapDepth Property
HasAxis Property
HasDataTable Property
HasLegend Property
HasPivotFields Property
HasTitle Property
HeightPercent Property
HostContext Property
Hyperlinks Property
Index Property
InnerObject Property
ItemProvider Property
Legend Property
Line3DGroup Property
MailEnvelope Property
Name Property
Next Property
OnDoubleClick Property
OnSheetActivate Property
OnSheetDeactivate Property
PageSetup Property
Parent Property
Perspective Property
Pie3DGroup Property
PivotLayout Property
PlotArea Property
PlotBy Property
PlotVisibleOnly Property
Previous Property
PrintedCommentPages Property
ProtectContents Property
ProtectData Property
ProtectDrawingObjects Property
ProtectFormatting Property
ProtectGoalSeek Property
ProtectionMode Property
ProtectSelection Property
RightAngleAxes Property
Rotation Property
Scripts Property
Shapes Property
ShowAllFieldButtons Property
ShowAxisFieldButtons Property
ShowDataLabelsOverMaximum Property
ShowLegendFieldButtons Property
ShowReportFilterFieldButtons Property
ShowValueFieldButtons Property
SideWall Property
Site Property
SubType Property
SurfaceGroup Property
Tab Property
Tag Property
Type Property
Visible Property
Walls Property
WallsAndGridlines2D Property
Expand Minimize
This topic has not yet been rated - Rate this topic

ChartSheetBase.ChartType Property

Visual Studio 2012

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 XlChartType ChartType { get; set; }

Property Value

Type: XlChartType
One of the XlChartType values.

Some chart types are not available for PivotChart reports.

The following code example uses the ChartType property to set the type of the current Microsoft.Office.Tools.Excel.ChartSheetBase to a 3-D clustered bar chart.

C#
VB
Copy 
private void AdjustChartSheet()
{
    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.ChartType = Excel.XlChartType.xl3DBarClustered;
}
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.