title: Add Grand Total to Pivot Chart in Data Table but not in graph
body: <p>So apparently Pivot Table, when converted into Pivot Chart, does not use the &quot;Grand Total&quot; line when asked to display the &quot;Data Table&quot; below the chart.</p>
  <p><a href="http://peltiertech.com/Excel/Pivots/pivotcharts.htm" rel="nofollow noreferrer">Online</a> and on <a href="https://stackoverflow.com/questions/14057861/add-totals-line-to-pivot-chart-in-excel-2010">Stackexchange</a>, 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.</p>
  <p>I did that but now I have Grand total showing up <em>both</em> in the Chart and the Table. I don't want that. I also don't have the competence to use &quot;Calculated Field&quot; to add a &quot;Grand Total&quot; in the pivot table but would appreciate being taught how to do that.</p>
  <p>Ok, so this is what I want:</p>
  <p><img src="https://i.stack.imgur.com/bSUlp.jpg" alt="enter image description here" /></p>
  <p>But these two are what I can manage:
  <img src="https://i.stack.imgur.com/j01dn.jpg" alt="enter image description here" />
  <img src="https://i.stack.imgur.com/QmWF8.jpg" alt="enter image description here" /></p>
  <p>How can I fix this?</p>