Automatically adjust Bar Graph when Pivot Table changes

PivotChart should reduce automatically.

No the Pivot table changes no problem, the chart on the other hand looks terrible that's what needs to get fixed. Any ideas

PivotChart. Insert it same way as Pivot table.

Insert -> Pivot -> PivotChart

Untitled.jpg

O.K. New at this PivotTable/PivotChart thing. Do I make the PivotChart from the PivotTable? or do I create it from the original Data table??

Thanks

Insert it same way as Pivot table from the original data.
Just use PivotChart and not PivotTable.

You'll get same case as with PivotTable (rest is same) only you have additional chart in the sheet.

O.K. Thanks everyone, I finally got the Dynamic Ranges working and it's almost all GOOD, except two last problems:

1) My Vertical Category Axis is feed with two Columns: Column 'A' giving the Position number and Column 'B' giving the name of the individual in the position. On the Chart the Position number is entered vertically while the Name is reported Horizontally. How Can I get both Horizontal? I can't stretch the Vertical Category Axis box and I can't find if/where I can change the Box size.

2) How do I set the height of the chart to adjust with the data so if it's only providing information on five positions as per the picture or 123 positions the graph is legible

Axis_Problem.png?

Post a WORKBOOK.
Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping.

Remove all private and confidential information.
Don't post them but keep similar information important to understand point.
I.e. [email protected] instead of true e-mail address. Change names. Values. Etc.