Subtotals in Pivot Charts?

[Excel_ZM]

I know you can add subtotals in pivot tables, but can you add subtotals in pivot charts?

Below is a small sample data. I would like a subtotal in chart for the Report Year.
Thank you.

Report filters: None
Legend Fields (Series): Type
Axis Fields (Categories): Report Year
Values: Sum of Values

[TABLE="width: 207"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Report Year[/TD]
[TD]Type[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]A[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]A[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]A[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]A[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]B[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]B[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]B[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]C[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]C[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]C[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]C[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]C[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]C[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]D[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]D[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]A[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]A[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]A[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]A[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]B[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]B[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]B[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]C[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]C[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]C[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]C[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]C[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]C[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]D[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD]D[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]

 

[Excel_ZM]

Basely, I would like a bar in the chart that shows
2014: 75
2015: 76

So maybe it is a grand total? Not subtotal?

 

[SpillerBD]

If you are familiar enough with Pivot Tables, create the PivotTable that would chart what you need to Chart. Then with a cell in the PivotTable select, Click the PivotChart in the PivotTable Tools/Analyze ribbon

 

[Excel_ZM]

The Analyze tab does not show a subtotal option. Am I missing something?

 

[SpillerBD]

The Analyze tab does not show a subtotal option. Am I missing something?

kinda

Build a New Pivot Table:
Rows: Report Year
Values: Value (Sum of Value)

Select a Cell in the Pivot Table.
Press F11

Your Table with the "Type" detail isn't what you really want in your chart. Pivot Charts are tied to the layout and filter of the source Pivot Table, so the second PT is needed.

 

[Excel_ZM]

It's a shame that I need a second PT just for the subtotal.
Or I could trick the pivot chart by adding the subtotals to the source table.