Gotcha: The Show Report Filter Pages trick (described in "Create a Report for Every Customer") doesn't work for a pivot chart. If you liked the cleaner look of a pivot chart without buttons, you can use the dropdown on the Excel 2010 Analyze tab to remove selected buttons.Īdditional Details: To filter the chart to a specific customer, you can change the Customer dropdown in the pivot table. Excel 2007 offered a PivotChart Filter Pane with the filter dropdowns. Gotcha: The button on the chart went away in Excel 2007 and came back in Excel 2010.
This chart is the result of a pivot table analysis. When you select the chart, you can use the PivotChart Tools tabs on the ribbon to control the chart type and all formatting. Add Revenue to the â Values drop zone.Įxcel will show both a pivot table and a chart on the worksheet. Add Customer to the Report Filter drop zone. Put Product in the Legend Field drop zone. Result: Note: enter a title by clicking on Chart Title. Column fields are now called legend fields. On the Insert tab, in the Charts group, click the Line symbol. Note that the row fields are now called axis fields. Build a pivot table by using the Field List dialog. Select Insert, PivotTable dropdown, PivotChart. Strategy: In Excel 2010, pivot charts have improved to the point where they are actually usable. 
Problem: Can I show the results of a pivot table in a chart?
0 kommentar(er)
