Aspose.Cells.Charts Namespace |
Contains all classes of chart and sparkline.
Classes| Class | Description | |
|---|---|---|
  | Axis |
Encapsulates the object that represents a chart's axis.
|
| AxisBins |
Represents axis bins
|
| Chart |
Encapsulates the object that represents a single Excel chart.
|
| ChartArea |
Encapsulates the object that represents the chart area in the worksheet.
|
| ChartCollection |
Encapsulates a collection of Chart objects.
|
| ChartDataTable |
Represents a chart data table.
|
| ChartFrame |
Encapsulates the object that represents the frame object in a chart.
|
| ChartGlobalizationSettings |
Represents the globalization settings for chart.
|
| ChartPoint |
Represents a single point in a series in a chart.
|
| ChartPointCollection |
Represents a collection that contains all the points in one series.
|
| ChartTextFrame |
Encapsulates the object that represents the frame object which contains text.
|
| DataLabels |
Encapsulates a collection of all the DataLabel objects for the specified Series.
|
| DisplayUnitLabel |
Represents the display unit label.
|
| DropBars |
Represents the up/down bars in a chart.
|
| ErrorBar |
Represents error bar of data series.
|
| Floor |
Encapsulates the object that represents the floor of a 3-D chart.
|
| Legend |
Encapsulates the object that represents the chart legend.
|
| LegendEntry |
Represents a legend entry in a chart legend.
|
| LegendEntryCollection |
Represents a collection of all the LegendEntry objects in the specified chart legend.
|
| Marker |
Represents the marker in a line chart, scatter chart, or radar chart.
|
| PivotOptions |
Represents a complex type that specifies the pivot controls that appear on the chart
|
| PlotArea |
Encapsulates the object that represents the plot area in a chart.
|
| Series |
Encapsulates the object that represents a single data series in a chart.
|
| SeriesCollection |
Encapsulates a collection of Series objects.
|
| SeriesLayoutProperties | |
| Sparkline |
A sparkline represents a tiny chart or graphic in a worksheet cell that provides a visual representation of data.
Examples[C#] Workbook book = new Workbook(); Worksheet sheet = book.Worksheets[0]; sheet.Cells["A1"].PutValue(5); sheet.Cells["B1"].PutValue(2); sheet.Cells["C1"].PutValue(1); sheet.Cells["D1"].PutValue(3); // Define the CellArea CellArea ca = new CellArea(); ca.StartColumn = 4; ca.EndColumn = 4; ca.StartRow = 0; ca.EndRow = 0; int idx = sheet.SparklineGroupCollection.Add(Aspose.Cells.Charts.SparklineType.Line, sheet.Name + "!A1:D1", false, ca); SparklineGroup group = sheet.SparklineGroupCollection[idx]; idx = group.SparklineCollection.Add(sheet.Name + "!A1:D1", 0, 4); Sparkline line = group.SparklineCollection[idx]; Console.WriteLine($"Saprkline data range:{line.DataRange}, row:{line.Row}, column:{line.Column}"); line.ToImage("output.png", new ImageOrPrintOptions()); |
| SparklineCollection |
Encapsulates a collection of Sparkline objects.
|
| SparklineGroup | Sparkline is organized into sparkline group. A SparklineGroup contains a variable number of sparkline items.
A sparkline group specifies the type, display settings and axis settings for the sparklines.
|
| SparklineGroupCollection |
Encapsulates a collection of SparklineGroup objects.
|
| TickLabelItem |
Include information of a Ticklabel item
|
| TickLabels |
Represents the tick-mark labels associated with tick marks on a chart axis.
|
| Title |
Encapsulates the object that represents the title of chart or axis.
|
| Trendline |
Represents a trendline in a chart.
|
| TrendlineCollection |
Represents a collection of all the Trendline objects for the specified data series.
|
| Walls |
Encapsulates the object that represents the walls of a 3-D chart.
|
Enumerations| Enumeration | Description | |
|---|---|---|
 | AxisType |
Represents the axis type.
|
| BackgroundMode |
Represents the display mode of the background.
|
| Bar3DShapeType |
Represents the shape used with the 3-D bar or column chart.
|
| BubbleSizeRepresents |
Represents what the bubble size represents on a bubble chart.
|
| CategoryType |
Represents the category axis type.
|
| ChartLineFormattingType |
Represents line format type of chart line.
|
| ChartMarkerType |
Represents the marker style in a line chart, scatter chart, or radar chart.
|
| ChartSplitType |
Represents the way the two sections of either a pie of pie chart or a bar of pie chart are split.
|
| ChartTextDirectionType |
Represents the text direction type of the chart.
|
| ChartType |
Enumerates all chart types used in Excel.
|
| CrossType |
Represents the axis cross type.
|
| DataLabelsSeparatorType |
Represents the separator type of DataLabels.
|
| DataLablesSeparatorType | Obsolete.
Represents the separator type of DataLabels.
|
| DisplayUnitType |
Represents the type of display unit.
|
| ErrorBarDisplayType |
Represents error bar display type.
|
| ErrorBarType |
Represents error bar amount type.
|
| FormattingType | |
| LabelPositionType |
Represents data label position type.
|
| LegendPositionType |
Enumerates the legend position types.
|
| MapChartLabelLayout |
Represents the layout of map chart's labels.
|
| MapChartProjectionType |
Represents projection type of the map chart.
|
| MapChartRegionType |
Represents the region type of the map chart.
|
| PlotDataByType |
Represents the type of data plot by row or column.
|
| PlotEmptyCellsType |
Represents all plot empty cells type of a chart.
|
| QuartileCalculationType |
Represents quartile calculation methods.
|
| SparklineAxisMinMaxType |
Represents the minimum and maximum value types for the sparkline vertical axis.
|
| SparklinePresetStyleType |
Represents the preset style types for sparkline.
|
| SparklineType |
Represents the sparkline types.
|
| TickLabelPositionType |
Represents the position type of tick-mark labels on the specified axis.
|
| TickMarkType |
Represents the tick mark type for the specified axis.
|
| TimeUnit |
Represents the base unit for the category axis.
|
| TrendlineType |
Represents the trendline type.
|