Compare Sales Results Graphically

Your product summary lets you consider the totals, but there’s a better way to compare the two product lines. You can create a chart from a PivotTable as you would from any data. As you make changes to the PivotTable or refresh the underlying data, the chart is updated too.

Chart Wizard button

To create a chart, first select the entire PivotTable, and then use the Chart Wizard to select the options you want. For more information, see Create a Chart from Worksheet Data.

Select data that includes a field button   You can select data such as cell A2 in the illustration above: On the PivotTable toolbar, click Select (PivotTable menu), and make sure the Enable Selection button is not pressed in. Then drag from the lower-right to the upper-left corner to select the data you want.

Next Steps