ColumnChart Class
Represents a chart whose series values are drawn using vertical rectangles.
public sealed class ColumnChart : ExcelChartPublic NotInheritable Class ColumnChart
Inherits ExcelChart- Inheritance:
- System.ObjectColumnChart
Properties
Axes
Gets the chart axes.
Property Value
The chart axes.
ChartType
Gets the chart type for ColumnChart which is Column.
public override ChartType ChartType { get; }Public Overrides ReadOnly Property ChartType As ChartTypeProperty Value
Overrides
Grouping
Gets or sets the chart grouping.
Property Value
The chart grouping.
SeriesGapWidth
Gets or sets the width of the series gap.
Default value is 2.19 if Grouping is Clustered; otherwise, 1.5.
Property Value
- System.Double
The width of the series gap in range from 0.0 to 5.0.
Exceptions
- System.ArgumentOutOfRangeException
Value is not between 0.0 and 5.0.
SeriesOverlap
Property Value
- System.Double
The series overlap in range from -1.0 to 1.0.
Exceptions
- System.ArgumentOutOfRangeException
Value is not between -1.0 and 1.0.
Inherited Properties
| CategoryLabels | Gets the chart's category labels. (Inherited from ExcelChart) |
| CategoryLabelsReference | Gets or sets the chart's category labels as a cell range reference (for example, 'Sheet1!A1:D1'). Values from cells in the referenced range will be used as category labels. (Inherited from ExcelChart) |
| DataLabels | Gets the settings for the data labels for the entire chart. (Inherited from ExcelChart) |
| Fill | Gets or sets the fill formatting options. (Inherited from ExcelChart) |
| Hyperlink | Gets or sets the hyperlink on this drawing (picture, chart, etc.). (Inherited from ExcelDrawing) |
| Legend | Gets the chart's legend. (Inherited from ExcelChart) |
| Metadata | Gets the metadata (non-visual properties) of this ExcelDrawing instance. (Inherited from ExcelDrawing) |
| Outline | Gets or sets the outline formatting options. (Inherited from ExcelChart) |
| PlotArea | Gets the chart's plot area. (Inherited from ExcelChart) |
| Position | Gets the position of this drawing (picture, chart, etc.) in the worksheet. (Inherited from ExcelDrawing) |
| RoundedCorners | Gets or sets a value indicating whether the chart area border has rounded corners. Default value is false. (Inherited from ExcelChart) |
| Series | Gets the chart's series. (Inherited from ExcelChart) |
| ShowDataInHiddenCells | Gets or sets the value which indicates whether only visible cells should be plotted on the chart. (Inherited from ExcelChart) |
| ShowEmptyCellsAs | Gets or sets the value which indicates how empty cells (cells with Value equal to null) shall be plotted on the chart. (Inherited from ExcelChart) |
| TextFormat | Gets or sets the text formatting options. (Inherited from ExcelChart) |
| Title | Gets the chart's title. (Inherited from ExcelChart) |
| UseSecondaryAxis | Gets or sets the value which indicates whether this chart should use the secondary axis of parent ComboChart. (Inherited from ExcelChart) |
| Worksheet | Gets the parent worksheet. (Inherited from ExcelDrawing) |
| ZIndex | Gets the z-order position of the picture. -1 if the picture is not contained in proper collection. (Inherited from ExcelDrawing) |
Inherited Methods
| BringForward() | Moves the chart one position forward in the drawings if the parent collection is ExcelChartCollection. (Inherited from ExcelChart) |
| BringToFront() | Brings the chart to the front of the drawings if the parent collection is ExcelChartCollection. (Inherited from ExcelChart) |
| ChangeChartType(ChartType) | Changes the chart to a different type of chart. (Inherited from ExcelChart) |
| ChangeChartType<TChart>() | Changes the chart to a different type of chart. (Inherited from ExcelChart) |
| Format() | Formats this drawing (picture, chart, etc.) to its default size so it can be exported to PDF, XPS, image or be printed. (Inherited from ExcelDrawing) |
| Format(System.Double, System.Double, LengthUnit) | Formats this drawing (picture, chart, etc.) to specified size so it can be exported to PDF, XPS, image or be printed. (Inherited from ExcelDrawing) |
| MoveZIndex(System.Int32) | Moves the picture forward or backward in the drawings with the given relative index if the parent collection is ExcelChartCollection. (Inherited from ExcelChart) |
| SelectData(CellRange) | Selects the data for the chart. (Inherited from ExcelChart) |
| SelectData(CellRange, System.Boolean) | Selects the data for the chart. (Inherited from ExcelChart) |
| SelectData(CellRange, System.Boolean, System.Boolean) | Selects the data for the chart. (Inherited from ExcelChart) |
| SelectData(CellRange, System.Boolean, System.Boolean, System.Boolean) | Selects the data for the chart. (Inherited from ExcelChart) |
| SelectData(System.String) | Selects the data for the chart. (Inherited from ExcelChart) |
| SelectData(System.String, System.Boolean) | Selects the data for the chart. (Inherited from ExcelChart) |
| SelectData(System.String, System.Boolean, System.Boolean) | Selects the data for the chart. (Inherited from ExcelChart) |
| SelectData(System.String, System.Boolean, System.Boolean, System.Boolean) | Selects the data for the chart. (Inherited from ExcelChart) |
| SendBackward() | Moves the chart one position backward in the drawings if the parent collection is ExcelChartCollection. (Inherited from ExcelChart) |
| SendToBack() | Sends the chart to the back of the drawings if the parent collection is ExcelChartCollection. (Inherited from ExcelChart) |
| SetCategoryLabels(System.Collections.Generic.IEnumerable<System.String>) | Sets the chart's category labels. (Inherited from ExcelChart) |
| SetCategoryLabels(System.String[]) | Sets the chart's category labels. (Inherited from ExcelChart) |
| ToString() | Returns a System.String that represents this ExcelChart instance. (Inherited from ExcelChart) |