Many of the options in the Chart Tools tab in the Spread Designer are also available when you right-click on a chart control that has been added to the Spread control. You can access these options at design time or run time.
The following options are available:
- The Cut, Copy, and Paste options allow you to cut, copy, and paste the chart control. Delete allows you to delete the chart control.
- The Change Chart Type option allows you to change the chart type (bar to pie, for example).
- The Select Data dialog allows you to change the range of data in the chart as well as edit the series or category names.
- The Switch Row/Column option swaps the category and series names and swaps the rows and columns of data.
- The Move Chart option brings up a Move Chart dialog that allows you to move the chart to another sheet view or a new sheet.
- The Format Chart Area option allows you to set backcolor, series shapes, etc. The area that you can format depends on what was selected before you right-clicked on the chart.
- The Chart Designer option brings up the chart designer.
- The View option allows you to set the chart to a 3D or 2D view.
The Change Chart Type option appears as follows:
The Select Data dialog appears as follows:
The Move Chart dialog appears as follows:
The Format Chart Area dialog appears as follows:
