excelfreak87
New Member
- Joined
- Feb 20, 2018
- Messages
- 5
Dear All,
I am working on an Excel dashboard. One of the requirements is to display monthly and quaterly data on a single graph depending on user's selection. If the user wants to see volumes per months, the graph should present monthly data. If the user chooses to see the quaterly data, the graph should show quarterly volumes. I tried with pivot charts and slicers but it doesn't work the way as I would like it to be. Do you have any ideas how I could implement this requirement? I really appreciate your help.
Many thanks,
S.
I am working on an Excel dashboard. One of the requirements is to display monthly and quaterly data on a single graph depending on user's selection. If the user wants to see volumes per months, the graph should present monthly data. If the user chooses to see the quaterly data, the graph should show quarterly volumes. I tried with pivot charts and slicers but it doesn't work the way as I would like it to be. Do you have any ideas how I could implement this requirement? I really appreciate your help.

Many thanks,
S.