HP 3PAR StoreServ 7200 2-node HP 3PAR System Reporter 3.1.0 Software User& - Page 101
Exporting Executable Reports, Customizing Excel Reports, Microsoft Office Excel Workbook
View all HP 3PAR StoreServ 7200 2-node manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 101 highlights
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. 2. On the shortcut menu, click Location (for Excel 2003) or Move Chart (for Excel 2007). The Chart Location (for Excel 2003) or Move Chart (for Excel 2007) dialog appears. 3. In the Chart Location or Move Chart dialog box, click As new sheet or New sheet and then click OK to move the chart to a new sheet. A new tab (with the specified name) appears at the bottom of the window for the new worksheet that holds the moved chart. NOTE: Moving a chart may cause it to be resized. When a chart becomes smaller, you can adjust the axis labels to make them more readable. To adjust the axis, right-click the axis, click Format Axis... on the shortcut menu that appears, and then use the controls in the Format Axis dialog box. 4. Identify the data sheet that contains the source data for the moved chart. For example, a chart generated with the PDIO reporting tool sheet is linked to data on either the PDSpace Time Data or PDSpace Items Data sheet. NOTE: If you don't know the name of the data sheet that holds the source data for a chart, you can right-click the chart and click Source Data..., then click the Series tab in the Source Data dialog box that appears. On the Series tab, look at the Name and Values boxes. The worksheet name appears in both boxes, just before the exclamation point. 5. Right-click the source data sheet tab and click Rename, then edit the data sheet name. Be sure to use a unique name that is not used for any other reporting tool or data sheets in the Excel client workbook. After editing the data sheet name, you can return to the reporting tool sheet to perform additional queries without affecting the relocated chart or the data sheet holding its source data. Exporting Executable Reports When working with reports generated through the Excel client, you have the ability to save the contents to a file where the formatted data can be accessed. This is useful when you want to have data in a given report accessible to anyone in a directory or to email the reports. Here are the steps for saving an executable report: 1. Click the appropriate tab at the bottom of the screen to access the report you want to save as an executable file. 2. Click the Windows Office Button in the upper right corner. 3. Choose Save As, then select Microsoft Office Excel Workbook (for Excel 2007, you also have the option of saving as (Excel Macro Enabled Workbook). 4. Assign a name to the file and click Save. Customizing Excel Reports Read this section for information on customizing the charts used to plot the results of database queries initiated with the HP 3PAR System Reporter Excel client. To customize a chart, you must edit the data sheet associated with that chart. Customized charts typically make use of custom columns added to a data sheet. Working with Excel Charts 101