Excluding fields and including totals from pivot chart

From screenshot, it doesn't look like you are using Excel 2003. What version are you using?
If different from 2003, please update your profile, so that solution is applicable to your version of Excel.

Originally Posted by benalt613

What approach is needed to get sums of A included per section with only the total from B included as a plot?

Pivot charts do not plot grand totals. And they do plot whatever is in the main body of the table. You'd probably need to load the data into the data model, create a new measure to total the B values regardless of section, then use a set to not display the 4 yellow columns.

What you are after can't be done within Pivot Table alone.

There are few workarounds...

1. Simply hide columns not needed. Though this may not be desirable, if column structure changes due to user interaction (slicer etc).

2. Do total calculation outside of pivot table, using CUBE function(s) and measures for the Total column.

To use CUBE function, I'd recommend loading source data into data model (and base Pivot off of it).

You can find good tutorial in link below.
https://www.excelcampus.com/cubevalue-formulas/

Another alternative is to create pivot table from Data model and then convert entire pivot to CUBE formula using PivotTable ribbon tools.
0.JPG

Then simply delete unwanted columns. Format range as needed. You can use "Refresh All" to update value as table is updated.

That can be used as basis for your chart (combined with named ranges).