Menu
So apparently Pivot Table, when converted into Pivot Chart, does not use the "Grand Total" line when asked to display the "Data Table" below the chart.
Online and on Stackexchange, it has been suggested that one should create a separate table, which has the values in the pivot table and then create a chart using that table.
I did that but now I have Grand total showing up both in the Chart and the Table. I don't want that. I also don't have the competence to use "Calculated Field" to add a "Grand Total" in the pivot table but would appreciate being taught how to do that.
Ok, so this is what I want:
But these two are what I can manage:
How can I fix this?
303
Click anywhere in the PivotTable. On the Design tab, in the Layout group, click Grand Totals, and then select the grand total display option that you want.
Show or hide grand totals Click anywhere in the PivotTable to show the PivotTable Analyze and Design tabs. Click Design > Grand Totals. Pick the option you want: Off for Rows & Columns.
Remove fields from the PivotTable or PivotChartIn the Choose fields box, clear the check box of the field you want to remove. Note: Clearing a check box removes all instances of the field from the report. In a layout area, click the field that you want to remove, and then click Remove Field.
On the second, chart where the total column is green, if you right-click on it and select format data series, you'll get this:
From there, go to fill on the left side, and select no-fill like this:
Once you've done, press close and your chart should look like this:
EDIT: You'll also need to delete the totals in the legend. You can do that by clicking the legend, then clicking total, and hitting the delete key.
119
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
