Custom Charts

In the spreadsheet module for ReliaSoft Workbooks, you can use the Document > Chart commands to insert your own custom charts. The charts can be placed anywhere in the spreadsheet, and are dynamic (automatically update when the data used to create the chart is changed).

Adding a Chart

  1. Select the cells that contain the data of interest. In the example data below, the headings are included in the selection and will be used as the legend labels.

  1. Choose Document > Charts. Choose the chart type, and then click a chart subtype that you want to use.

  1. To move the chart, click and drag the chart to the desired location.

  2. To resize the chart, click the chart and then drag the sizing handles to the desired size.

Changing the Data Displayed on an Axis

To change the way the data series is displayed on the axes, click the chart, then choose Design > Data > Switch Row/Column.

Changing the Chart Type and/or Data Set  

You can change the type of chart and/or the data that is used in a chart at any time. To do this, click the chart and then:

Applying a Chart Layout and/or Chart Style

If none of the predefined options are suitable for your chart, choose Layout > Labels, then select the option you want to customize. The following picture shows the options for the vertical axis.

Renaming Chart and Axes Titles

When displaying chart and/or axes titles, you can rename the titles by right-clicking the chart and selecting the appropriate title option from the shortcut menu. For example, choosing Change Chart Title opens the following window:

Modifying the Axes and Gridlines

To hide or display axes and/or gridlines, choose Layout > Axes > Axes or Gridlines.

or

Related Topics and Links