Hi,
I have recently developed a "dashboard" within an Excel file with huge amount of data to summarize some of the key figures. I have included "buttons" to switch among regions by having a macro changing formulas in the cells where each chart is taking its data from.
example clean.PNG
Though, whenever I switch to another country, the % change between two fiscal years moves uncontrollably around (see below), which makes it unreadable/ useless. It would be a pain and not very user friendly to change it manually every time. Is there a way to make the % changes "stick" to the corresponding bar chart? I'm currently using a bar chart (sales value) and line chart (% change), where the line itself is hidden as I just want to see the percentages but on top of the right bar. Is there a way to do that? or does Excel not have such a feature? Does anyone know? been trying to figure this out for quite some time now...
example messy.PNG
Bookmarks