Forum Discussion
Solved
Entering chart titles for chrats created using pivot tables.
Hello,
Have created chrats using pivot tables and charts for a huge data set and want to name the chrats respectively, is it possible to name all the chrats using some kind of formula. Because naming them manually is consuming huge time as they are around 3k charts.
Looking forward for some solution.
Have attached a file and the querry too in the excel sheet please have a look at it.
Regards,
Aditya.
HI Aditya,
Sorry, i didn't catch how you structure your data (merged columns in main table, is one ID = one Title or not, why not separate table if so, etc) and why do we spaeak about two slicer = i found only one slicer fo ID here.
Anyway, back to titling - there are two main approach to pickup slicer value. Use cube formulas and use helper pivot table. More details for example here http://chandoo.org/wp/2015/06/24/introduction-to-slicers/
Since you don't load your pivot to data model, we may use helper pivot.
In attached file i added one more pivot table with value of min dates (my guess your dates are linked to ID:s, but you may use any other vakue here);
linked your ID slicer to that table through slicer connections;
formatted value in new pivot table;
linked chart title to first row of new pivot table as link in previous table
That's just sample, you may add checking if more than one row selected, if nothing is selected, if you have more connected slicers.
The idea is this helper pivot table returns exactly the values selected in slicers (not but slicers).
Hi Aditya,
Yes, sure. Combine dynamic title with formulas in any cell and after that link chart title with this cell through formula bar. How to do that is, for example, here http://blog.contextures.com/archives/2012/11/06/link-pivot-chart-title-to-report-filter/
- first what i find. Google will give much more.
Hi,
Tried a lot of things when i have a single slicer as a filter the chart titles can be named perfectly but as it is that i do have a slicer already in my pivot table which is making it difficult to name those tiltes just with the above given link need help in doing it correctly.
Attaching a file below which will show a clearer picture what im facing right now.
Regards,
Aditya
HI Aditya,
Sorry, i didn't catch how you structure your data (merged columns in main table, is one ID = one Title or not, why not separate table if so, etc) and why do we spaeak about two slicer = i found only one slicer fo ID here.
Anyway, back to titling - there are two main approach to pickup slicer value. Use cube formulas and use helper pivot table. More details for example here http://chandoo.org/wp/2015/06/24/introduction-to-slicers/
Since you don't load your pivot to data model, we may use helper pivot.
In attached file i added one more pivot table with value of min dates (my guess your dates are linked to ID:s, but you may use any other vakue here);
linked your ID slicer to that table through slicer connections;
formatted value in new pivot table;
linked chart title to first row of new pivot table as link in previous table
That's just sample, you may add checking if more than one row selected, if nothing is selected, if you have more connected slicers.
The idea is this helper pivot table returns exactly the values selected in slicers (not but slicers).
Hello Sergei,
Thank you for the link will surely go through it.
Regards,
Aditya
