Files to look at:
- AxesActions.cs (VB: AxesActions.vb)
- Charts.cs (VB: Charts.vb)
- ChartSheetActions.cs (VB: ChartSheetActions.vb)
- CreationAndDataActions.cs (VB: CreationAndDataActions.vb)
- DataLabelsActions.cs (VB: DataLabelsActions.vb)
- LegendActions.cs (VB: LegendActions.vb)
- Protection.cs (VB: Protection.vb)
- SeriesActions.cs (VB: SeriesActions.vb)
- StyleActions.cs (VB: StyleActions.vb)
- TitlesActions.cs (VB: TitlesActions.vb)
- ViewOptionsActions.cs (VB: ViewOptionsActions.vb)
This example demonstrates how to use the SpreadsheetControl Chart API to programmatically manage charts in worksheets.
The application includes the RichEditControl (at the top) used to display and edit the code and the SpreadsheetControl (at the bottom) which shows the result of code execution.
You can modify the code and watch the result. The code is executed every two seconds. If an error occurs during compilation or execution, the code window background color turns to pink.
Starting from v2017 vol.2:
- Create and manage chart sheets in a workbook