Chart Commands

A Chart command is hot-linked to a chart. When updated, it inserts a picture of the chart into the command. You change the settings for a Chart command from the Edit Command Panel in the Report Navigator.

tog_minusChart Controls

Chart Command - Chart Controls

The Chart text displays the location of the linked chart. The number in brackets is the file ID. The rest of the text string is the chart's name. To view the linked chart, click on the Go to Chart Button. To change the linked chart:

Step01Select the Chart

Select the chart that you want to link to.

wTo link to the report's Analysis file, use Analysis Mode to select the chart.

wTo link to a standard Excel workbook file, use Workbooks Mode to select the chart.

Step02Copy the Chart

Click on the Copy Link Button in the Desktop Toolbar. You can also select Edit | Copy Link.

Step03Paste the Chart

Go to to Report Mode and click on the Paste Chart Button in the top right corner of the Edit Command Panel.

Step04Update the Command

Click on the Apply button in the lower right corner of the Edit Command Panel. The new chart will be applied to the command.
tog_minusColor Control

Chart Command - Color Control

The Color control sets the color format of the chart image.

Color Format

 

Effect

Color

 

Chart colors are the same as in the spreadsheet.

Black and White

 

Sets the chart colors to black and white. Equivalent to Word’s UI command: Format | Picture | Picture Tab | Image Control | Color = Black & White.

Grayscale

 

Sets the chart colors to grayscale. Equivalent to Word’s UI command: Format | Picture | Picture Tab | Image Control | Color = Grayscale.
tog_minusWidth Controls

Chart Command - Width Controls

You can let the software set the width of the chart's image, or you can set the width manually.

Default (autosize)

The default width of the chart is the same as in the spreadsheet, unless the spreadsheet chart is wider than the page width in the report. In this case, the chart width becomes the page width.

Custom

The Custom field sets the width of the chart in inches. Widths greater than the page width (up to 20") are allowed; in these cases, the displayed chart extends off the page and appears truncated. Regardless of how the width is set, the height of the chart is calculated to preserve the same aspect ratio as in the spreadsheet.