Add the sum in Pivot chart

%3CLINGO-SUB%20id%3D%22lingo-sub-2274029%22%20slang%3D%22en-US%22%3EAdd%20the%20sum%20in%20Pivot%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2274029%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20creating%20a%20pivot%20chart%20from%20pivot%20table%20with%20total%20sum-%20the%20total%20sum%20won't%20show%20in%20the%20chart-%20how%20do%20I%20add%20this%3F%20I%20don't%20want%20to%20make%20another%20table%20with%20just%20numbers%20somewhere%20else%20and%20make%20a%20simple%20chart%2C%20I%20want%20it%20to%20update%20directly%20based%20on%20the%20filter.%3C%2FP%3E%3CP%3EUsing%20Microsoft%20365%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Denise82_0-1618474999958.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F273000i600F9E657D8C985F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Denise82_0-1618474999958.png%22%20alt%3D%22Denise82_0-1618474999958.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2274029%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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

Denise82_0-1618474999958.png

 

3 Replies

@Denise82 

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...

 

  • first of all make sure that the Generate GetPivotData option is checked in Pivot Table Options. Refer to the screenshot below to confirm that.

 

Generate GetPivotData.jpg

 

  1. Then in a blank cell type = and click on the Grand Total cell in the Pivot Table.
  2. Now select your Pivot Chart.
  3. Go to Insert --> Shapes --> Insert a TextBox
  4. While the TextBox is selected, click in the Formula Bar and type = and click the formula cell you just created in step1 and hit Enter.

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.

@Subodh_Tiwari_sktneer That's a perfect solution, thank you a million!

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.