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

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.