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:

Return to Using the Chart Control.