Dynamic bar Chart - Largest to smallest - Excluding zeros and blanks

Hello,

create individual and unique column labels in row 3. Then select A3 to M15 and insert an Excel Table (Insert > Table>

With any cell in the table selected, insert a pivot chart. Drag Film into the Axis Category panel and Total Dollars into the values panel. Click the drop-down on the Value field entry, edit the value field settings and ensure that the aggregation is using "Sum" not "Count".

Right-click a film title in the pivot table, select Filter > Value Filters and filter for values greater than 0.
Right-click a number in the pivot table, select Sort and sort largest to smallest.

Now you can add new data to the original data table or edit existing data. Refresh the pivot table to see the changes reflected in the chart.

The only thing that is missing from your requirements is that the width of the columns will adjust, depending how many columns the chart is showing. The chart area will stay the same size, so column width is adjusted to accordingly.

If you want the chart area to grow or shrink with more of fewer columns, then you will need to use VBA and it might get messy.

see attached.

Cheers, teylyn