qr code excel 2010 PIVOT CHARTS in Microsoft Excel

Draw QR Code JIS X 0510 in Microsoft Excel PIVOT CHARTS

1. In the pivot table, select the cells you want to include in the chart. In this example, select cells A4:B21, which contain the wait days and the count of work orders. 2. Right-click one of the selected cells, and then click Copy. 3. Right-click the cell where you would like to paste the linked cells, and then click Paste Special. In this example, the data is pasted onto the PivotLink worksheet. 4. In the Paste Special dialog box, click Paste Link. Add headings above the linked data, such as Days and WOs. 5. To create a chart, select a cell in the linked data. 6. On the Ribbon s Insert tab, click the Scatter command, and then click the first chart subtype. This creates a scatter chart on the same worksheet as the linked data. 7. Format the chart as desired.

You created a pivot chart for the sales manager to use at the upcoming budget meeting. The pivot chart is on its own chart sheet, and when you want to select a different category in the Report Filter, you have to go to the pivot table and make the changes. You want it to be easy for the sales manager to select a different category or change the chart layout during the meeting, without having to leave the chart sheet. This problem is based on the Filter.xlsx sample file.

If you display the PivotChart Filter pane and the PivotTable Field List pane, you can make the layout and filter changes while working on the chart. Follow these steps to display these panes: 1. Select the pivot chart, and on the Ribbon, click the Analyze tab. 2. In the Show/Hide group, click Field List, to display the PivotTable Field List pane, and then click PivotChart Filter, to show the PivotChart Filter pane (see Figure 10-3).

Hide the PivotTable Field List pane and the PivotChart Filter pane after you finish modifying the pivot Tip

The PivotTable Field List lets you change the pivot chart layout, and the PivotChart Filter pane lets you filter the fields in the pivot chart. Using the PivotTable Field List The PivotTable Field List can be visible or hidden when a pivot chart is active. Use it to move fields in and out of the chart layout, or to a different area of the pivot chart layout. When the pivot chart is active, two of the area names change, to match the areas in the chart: The Column Labels area changes to the Legend Fields (Series) area. The Row Labels area becomes the Axis Fields (Categories) area. Move fields from one area of the PivotTable Field List to another, or add or remove fields from the pivot table layout. This changes the chart s appearance, as well as the pivot table on which the pivot chart is based. Using the PivotChart Filter Pane The PivotChart Filter pane (see Figure 10-4) enables you to filter the fields in the pivot chart s Report Filter, Axis Fields (Categories), or Legend Fields (Series) areas. You can also use it to sort the axis fields and legend fields.

Figure 10-4. The PivotChart Filter pane At the top right of the PivotChart Filter pane is a button that toggles the PivotTable Field List from visible to hidden (see Figure 10-4). To filter a field, click the arrow in the field s drop-down list, and then check the items you want to show. These filters work just as they do for the fields in the pivot table. For the axis and legend fields, you can also apply Value, Date, and Label filters from the filter drop-down lists. To sort the axis or legend fields, click the arrow in the field s drop-down list, and then click one of the sort options.