comfortnax.blogg.se

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. Column fields are now called legend fields.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?