Notifications
Clear all
Excel Dashboards
3
Posts
2
Users
0
Reactions
100
Views
Topic starter
Hi,
What charts would you recommend to show stock levels offtake and / or intake over a period of time?
I currently use a bar chart to visualize capacity vs inventory per each storage space.
Then I use a timeline to show daily inventory levels. Would I be able to switch the views from daily to weekly/monthly and all data to be aggregated correctly?
I would be grateful if you could point me in the right direction 🙂
Many thanks,
Oana
Posted : 13/08/2021 7:51 pm
Hi Oana,
It sounds like the column chart is ideal. You can use expand and collapse buttons on a PivotChart to switch views from daily to weekly etc.
Hope that helps.
Mynda
Posted : 13/08/2021 9:14 pm
Topic starter
Thank you Mynda
Posted : 14/08/2021 4:40 am
