# Using Charts

RadSpreadProcessing allows you to add and manipulate charts in your spreadsheet documents. The available API enables you to insert and modify different types of charts.

The chart objects are stored in the `Charts` collection of the worksheet and are represented by the `FloatingChartShape` class. The `FloatingChartShape` object exposes a `Chart` property of type `DocumentChart`.

## FloatingChartShape

The charts are wrapped in shapes. The `FloatingChartShape` class derives from `FloatingShapeBase` and represents the wrapper that allows you to add a chart to a document.

The `FloatingChartShape` class exposes the following constructors, which parse the data in the *chartDataRange* parameter and create a chart with all data already filled:

* `FloatingChartShape(Worksheet worksheet, CellIndex cellIndex, CellRange chartDataRange, params ChartType[] chartTypes)`

* `FloatingChartShape(Worksheet worksheet, CellIndex cellIndex, CellRange chartDataRange, SeriesRangesOrientation seriesRangesOrientation, params ChartType[] chartTypes)`

  The parameters accepted by the constructors are as follows:

  | Parameter                 | Description                                                                                                                                 |
  | ------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------- |
  | `worksheet`               | The worksheet that the shape is associated with.                                                                                            |
  | `cellIndex`               | The cell index where the top left corner of the shape is positioned.                                                                        |
  | `chartDataRange`          | The range containing the chart data.                                                                                                        |
  | `seriesRangesOrientation` | A value indicating whether the series of the chart refer to vertical or horizontal ranges, or if the direction is determined automatically. |
  | `chartTypes`              | The types of chart to create. **Passing more than one type creates a combo chart.**                                                         |

  > The number of `chartTypes` must be no more than the number of columns inside the `chartDataRange` minus one (the first column populates the X axis). Otherwise, a `System.NullReferenceException` is thrown.

Once you have created a `FloatingChartShape`, you can insert it in the document through the `Add()` method of the worksheet `Charts` property.

> Ensure that you have set the size of the `FloatingChartShape` object. Otherwise, it is inserted in the worksheet with zero size and is invisible.

**Example 1: Create a chart through FloatingChartShape and add it to a worksheet**

```C#
FloatingChartShape chartShape = new FloatingChartShape(worksheet, new CellIndex(6, 4), new CellRange(1, 1, 5, 2), ChartType.Column)
{
	Width = 460,
	Height = 250
};

worksheet.Charts.Add(chartShape);

SeriesGroup seriesGroup = chartShape.Chart.SeriesGroups.First(); // type BarChart
int seriesCount = seriesGroup.Series.Count(); // 1
SeriesBase series = seriesGroup.Series.First(); // type BarSeries
```

The result of executing the code in **Example 1** looks like **Figure 1**.

**Figure 1: Column chart added to a worksheet from year and income data**

![Telerik Document Processing RadSpreadProcessing worksheet showing a column chart titled Income created from year and income data](https://www.telerik.com/document-processing-libraries/documentation/assets/a8bf418a845d3b641f44b00d5d74917e/spreadprocessing-features-usingcharts_1.png)

The `Chart` property of `FloatingChartShape` holds an object of type [DocumentChart](https://www.telerik.com/document-processing-libraries/documentation/libraries/radspreadprocessing/features/charts/using-charts#documentchart).

**Example 2: Create a combo column and line chart through FloatingChartShape**

```C#
FloatingChartShape chartShape = new FloatingChartShape(worksheet, new CellIndex(0, 5), new CellRange(0, 0, 12, 3), new[] { ChartType.Line, ChartType.Line, ChartType.Column })
{
	Width = 400,
	Height = 250
};

worksheet.Charts.Add(chartShape);
```

The result of executing the code in **Example 2** looks like **Figure 2**.

**Figure 2: Combo chart with line and column series added to a worksheet**

![Telerik Document Processing RadSpreadProcessing worksheet showing a combo chart with Data1 and Data2 lines and Data3 columns by month](https://www.telerik.com/document-processing-libraries/documentation/assets/aa86973006c4360a5e08decbf2ceadc9/spreadprocessing-features-usingcharts_3.png)

### Changing the Appearance of FloatingChartShape

The `FloatingChartShape` class exposes properties that allow you to customize the shape appearance. You can control the outline of the shape and its fill.

**Example 3: Customize the fill and outline of FloatingChartShape**

```C#
FloatingChartShape chartShape = new FloatingChartShape(workbook.ActiveWorksheet, new CellIndex(2, 7), new CellRange(0, 0, 4, 3), ChartType.Column)
{
	Width = 480,
	Height = 288,
};

chartShape.Outline.Fill = new SolidFill(new ThemableColor(Colors.LightGray));
chartShape.Outline.Width = 5;
chartShape.Fill = new SolidFill(new ThemableColor(Colors.Aquamarine));
```

The result of executing the code in **Example 3** over a cell range containing sample data looks like **Figure 3**.

**Figure 3: Chart shape with customized background fill and outline styling**

![Telerik Document Processing RadSpreadProcessing chart with a light background and customized outline around the chart area](https://www.telerik.com/document-processing-libraries/documentation/assets/5a54fe15fb2f07ff0939eaf1a8d258f7/spreadprocessing-features-usingcharts_2.png)

> note The series are styled using the colors defined in the [Document Theme](https://www.telerik.com/document-processing-libraries/documentation/libraries/radspreadprocessing/features/styling/document-themes).

## DocumentChart

The `DocumentChart` object represents the chart itself and contains the following properties:

| Property        | Description                                                                                                          |
| --------------- | -------------------------------------------------------------------------------------------------------------------- |
| `SeriesGroup`   | Represents a collection of the groups in which the series of the chart are organized.                                |
| `PrimaryAxes`   | Represents the primary group of axes of the chart.                                                                   |
| `SecondaryAxes` | Represents the secondary group of axes of the chart. Used when there is more than one group of series (combo chart). |
| `Title`         | Represents the title of the chart.                                                                                   |
| `Legend`        | Represents the legend of the chart.                                                                                  |

The class also exposes a `Clone()` method, which creates a deep copy of the object.

You can create an empty `DocumentChart` object and then set the desired values manually.

**Example 4: Create an empty DocumentChart and set its values manually**

```C#
DocumentChart chart = new DocumentChart();
//Fill the chart with data
SeriesGroup seriesGroup = new BarSeriesGroup();
chart.SeriesGroups.Add(seriesGroup);

WorkbookFormulaChartData seriesValuesData = new WorkbookFormulaChartData(worksheet, new CellRange(2, 2, 5, 2));
WorkbookFormulaChartData seriesCategoriesData = new WorkbookFormulaChartData(worksheet, new CellRange(2, 1, 5, 1));
seriesGroup.Series.Add(seriesCategoriesData, seriesValuesData);

chart.PrimaryAxes.CategoryAxis = new DateAxis();
chart.PrimaryAxes.ValueAxis = new ValueAxis();

(seriesGroup as ISupportAxes).AxisGroupName = AxisGroupName.Primary;
```

You can then use the chart to replace the chart in an existing `FloatingChartShape`.

**Example 5: Add the DocumentChart to a worksheet**

```C#
chartShape.Chart = chart;

worksheet.Charts.Add(chartShape);
```

> note For more information about series, see the [Chart Series](https://www.telerik.com/document-processing-libraries/documentation/libraries/radspreadprocessing/features/charts/series) article. For a description of the axes objects, see [Working with Axes](https://www.telerik.com/document-processing-libraries/documentation/libraries/radspreadprocessing/features/charts/axes).

The initial data and the resulting chart are shown in **Figure 1**.

## Iterating the Charts of a Worksheet

You can access the `Charts` collection of the `Shapes` collection of the `Worksheet` instance and enumerate the charts.

**Example 6: Iterate all charts in a worksheet**

```C#
foreach (FloatingChartShape chartShape in worksheet.Charts)
{
	DocumentChart chart = chartShape.Chart;
	SeriesGroup group = chart.SeriesGroups.First();
	SeriesBase series = group.Series.First();
}
```