Dynamic Chart Title with Slicers

preview_player
Показать описание

Learn Excel Fast:

Here's the situation. We have created a PivotTable and related PivotChart, and, since we are nice, we have also provided a Slicer so that the user can easily make selections. But, we'd like the report titles to dynamically update based on the selections made. As with anything in Excel, there are multiple ways to accomplish this. In this video, we'll use a helper PivotTable.
Рекомендации по теме
Комментарии
Автор

I actually stumbled on this method myself and didn't realise you had a video on it. Great technique and I love your alternative to TEXTJOIN using SUBSTITUTE, TRIM and CONCATENATE...good one that's new to me 👍

UpExcel
Автор

Great techniques and I love your mind to use TEXTJOIN using SUBSTITUTE, TRIM and CONCATENATE. Awesome

kambizradman
Автор

Era exactamente lo que andaba buscando. Gracias!

estebanjara
Автор

Hi
Nice video
Question
How can add 2 cells to chart title , please write formula if is possible
Thank you

mohammadafsari