Apr 15 2021 01:27 AM
When creating a pivot chart from pivot table with total sum- the total sum won't show in the chart- how do I add this? I don't want to make another table with just numbers somewhere else and make a simple chart, I want it to update directly based on the filter.
Using Microsoft 365
Apr 15 2021 01:59 AM
If you are talking about showing the Column Grand Totals in the Pivot Chart, you may insert CheckBoxes in your Pivot Chart to show them. To do so follow these steps...
That way you may insert two TextBoxes in the Pivot Chart for both the series and change the font color to match the chart series color.
Apr 15 2021 05:15 AM
@Subodh_Tiwari_sktneer That's a perfect solution, thank you a million!
Apr 15 2021 06:42 AM
You're welcome @Denise82! Glad it worked as desired.
Please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.