3 retaining charts, Retaining charts – HP 3PAR System Reporter Software User Manual

Page 147

Advertising
background image

5.55

Working with Excel Charts

System Reporter 2.8

3PAR System Reporter User’s Guide

Figure 5-20. External Data Range Properties Dialog Box

3

Click OK.

5.4.3 Retaining Charts

The 3PAR System Reporter Excel client workbook is designed to reuse data sheets, redrawing

charts on the reporting tool sheets with updated data or modified query parameters as

required. To redraw a chart on a reporting tools sheet with updated data or modified query

parameters, use the reporting tool sheet controls to make any changes and then click

Refresh. The values on the corresponding data sheet are updated and the charts on the

reporting tool sheet are redrawn.

It is also possible to retain a chart for further reference. This can be done by moving the chart

and the data sheet linked to that chart to new worksheets. See the instructions that follow for

a detailed description of how to complete this procedure.

To retain a chart for further reference

1

On the chart to be retained, right-click to bring up the shortcut menu.

Advertising