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
A pie chart displays only one series. In this case, Priority Low.
Since Awaiting Triage and French Translation are blank in this series, their pie segment cannot be shown.
If you want to display all series, create a donut chart.
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.
