Forum Discussion
PivotChart doesn't show all data
How to get my pie chart to reflect all of the data in PivotTable. Per example, the legend seems to capture all of the data but the chart doesn't reflect the same. Please advise. Thanks
But I want to chart the Grand Total %s only and they all have data.
A pivot chart does not display the grand totals, only the individual series.
You might create a pivot table without Priority in the Columns area (i.e. only Category in the Rows area and Defect ID in the Values area), then create a pie chart from that pivot table.
That worked! Thanks