If multiple Regions are selected, the formula ends with “Multiple Regions”.If ALL Regions are selected, the formula ends with “All Regions”.IF(C2=”(Multiple Items)”, “Multiple Regions”, The formula result ending depends on what is selected in the pivot table’s Region filter The ampersand operator ( & ) joins that string with the text that follows it. The formula result starts with the text string: IF(C2=”(Multiple Items)”, “Multiple Regions”, C2)) Formula Beginning In this example, the following formula is in cell G1: Instead of typing some text in the chart title, you can use a worksheet formula to create a dynamic title.
The video below shows the step-by-step instructions.Īfter you create an Excel Pivot Chart, you can add a title at the top, to explain what the chart shows.Įxcel inserts a generic Title, which you can change, move, and format. Then, when you make a selection in the Report Filter, the chart title will change too.
Instead of adding a static title to your Pivot Chart, use a worksheet formula to create a dynamic chart title.
