Cost Analysis Report Presentation

[bejayrocks]

Righto Folks,


This is gonna be my first post in these forums, I'll start with common Ozzie greetings by saying G'Day.


Thanks to this great knowledge sharing platform I have figured out how to plot waterfall charts and customise it to my needs. Next step is to achieve the following without VBA. Now I do realise that this isn't much of a excel question but looking at the experts and auidence here I'm hoping someone would have endeavoured to do the same


After I analyse and prepare drill down graphs on every cost center and export the graphs to power point I want to be able to click on a specific data point and hyperlink it to open the graph slide relevant to that data point without having to add action buttons.


Any help would be much appreciated


Thanks

Bejay

 

[moestomib]

you can do right click on graph, and then you can add if condition or any condition statement at formula row. So the graph will be change exactly what you want.


-best regard-

yusvi