Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

Learn how to use a macro to create descriptive and dynamic pivot chart titles in Excel.
Download the Excel file: https://www.excelcampus.com/vba/pivot-chart-title-macro/
The default pivot chart titles default to the words "Total" or "Chart Title". This is NOT very descriptive and leaves us having to manually modify the title. So, I created a few macros that automate this process.

The macros use the used fields in the Areas of the pivot chart (pivot table) to create a descriptive title. This includes a simple macro that uses the field names (captions) in the Values, Rows, and Columns areas to create a chart title.

I've also included a more advanced macro that creates a dynamic subtitle. The subtitle includes the fields used in the Filters area of the chart and the filter criteria for each field.

That macro also uses another technique to display multiple items in the filter criteria as comma separated values, instead of the (Multiple Items) label.


This works well when you have a chart on a dashboard with slicers, and you want to display the filter criteria as text within the chart.
00:00 Introduction
03:12 Running the Macro
05:30 Dynamic Pivot Chart Filters Textbox
08:00 Dynamic Pivot Chart Subtotal