This decision will determine how you craft your pivot chart. The style of the chart and the columns that are used will depend on this one statement of conclusion. For instance, a bar chart is useful for representing the data under differing conditions, such as sales per region, while a pie chart can be used to display percentages or portions of a whole.
In Excel 2003, this will be under the “Data” menu. In Excel 2007 and 2010, you will find this on the “Insert” tab.
For instance, if your source data is a spreadsheet of sales by product and customer name, you may choose to drop either the customer name or the product column label into the “Axis Field” section. You would drag the column label for the sales amounts into the “Values” section.
Try a few different chart types until you find the type that best represents the point you want to make.
It can be placed in one corner of the source data sheet, on the same tab as the pivot table or on its own tab.
