Define Charts Using Named Ranges

User's Guide > About the User's Guide > Word and Excel Templates > Excel Templates > Adding Charts > Define Charts Using Named Ranges

Now that the named ranges are defined on the sample data, you can create a chart. Insert a Pivot Chart and Pivot Table by doing the following:

1. Create a new Charts sheet

2. Click Insert.

3. Click PivotChart.

4. The Create Pivot Table dialog appears. Select the range containing the data by using the Select a table or range dialog.

5. Pick the named range defined earlier that contains the data for the chart.

6. Pick the named-range which was defined earlier that contains the data for the chart.

7. Save the dialog.

The Pivot Chart and Table are empty. To select the data it will display, use the Pivot-Table sidebar:

Now the Pivot table and chart is added, yet it is empty. To select the data it will display use the Pivot-Table sidebar:

• Select one of fields appearing, here the Module.

• The pivot table now shows data, yet the pivot-chart is still empty. To fill the values of the pivot chart, move one of the fields to the Values section on the sidebar. In this example, dragging the Module field will do:

The exporter must ignore the charts and the data in the pivot tables, even if they contain some scripts. To do so, add a <jt:null> tag around the chart so that part won't be touched. For example,

The Pivot Table and Pivot Chart are ready, both showing the sample data and referencing the sample data being exported.

Was this helpful?