Charts

## Charts **Document Solutions for Excel** provides a comprehensive charting API: - Add charts to a worksheet using the **IWorksheet.AddChart** method -- Returns an instance of **IShape** -- Use the **Chart** property to access the newly added chart - Add data series with the **IChart.SeriesCollection.Add** method - Customize chart titles with the **IChart.ChartTitle** property - Customize chart legends with the **IChart.Legend** property - Access and customize each data series through the **ISeries** interface - Customize each data point in a data series using the **IPoint** interface - Add, remove, or customize each data label in a series using the **IDataLabel** interface - Access and customize a group of series through the **IChartGroup** interface - Access and customize value axes, category axes, and series axes using the **IAxis** interface - Add user shapes to a chart using the **IChart.Shapes.AddXXX** method Over and above the basic usage of each chart feature, you can change the **ISeries.ChartType** to create combination charts. You can even specify whether to plot a series on the primary or secondary axis with the **ISeries.AxisGroup** property. Each series in a chart is associated with a chart group. Typically there is one chart group for each chart type. Multiple chart groups are created automatically when you use combination charts. The **IChartGroup** interface provides options that let you customize the appearance of every series in a group. For example, you can set these properties on certain chart types: - **StartAngle** for pie charts - **GapWidth** for bar or column charts - **HasHiLoLines** and **HasUpDownBars** shows or hides stock chart options on a line chart The **IAxis** interface provides options that let you customize the appearance of chart axes. For example, you can use these properties on certain axis types such as: - **MinimumScale** and **MaximumScale** for a value axis - **TickLabelSpacing** for a category axis - **HasMajorGridlines** and **HasMinorGridlines** for a value axis Many chart objects (chart area, plot area, chart title, legend, series) provide a **Format** property so you can access and modify: - **fills** solid or gradient - **lines** dashed or transparency