Forum Discussion

Lobojo's avatar
Lobojo
Helper I
4 years ago
Solved

Barchart with aggregation

Hi,   in Excel I was able, from a simple file with 2 levels, to create a bar chart were one of the levels were aggregated, using a Pivot table please see example below.   Is there any chance to d...
Need Help
Tutorial Requests
ghoshabhijeet's avatar
ghoshabhijeet
Solution Supplier
4 years ago

Lobojo  I would then suggest you to use the Drill Down feature. You can keep the chart to the top most value in X-Axis. When the user would like to see the values under it, they may drill down and see Action values for the respective Function.

 

Snapshot below:

1. Initially your chart would be at the top level

2. If the user wants to drill down, they need to select the highlighted button and drill down on their respective Function

Hope this solution works for you.

 

 

** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !

Good Luck 👍

 

  • Lobojo's avatar
    Lobojo
    Helper I
    4 years ago

    Thanks, but this not what I was looking for. I need a full overview, not function by function. Anyway thanks a lot for your time.