May 30 2020 11:44 PM
Hi!
I would like to present Inventory aging with volume for multiple warehouses in single chart. I have tried radar, donut, sunburst etc. However was not able to create it. My data is like
Aging | Wh1 | Wh2 | Wh3 | Wh4 | Wh5 | Wh6 |
<30 D | 146 | 649.5 | 671 | 654.8 | 124 | 88 |
31-60 D | 62 | 108 | 342 | 115.55 | 16.5 | 23.5 |
61-90 D | 0 | 6 | 0 | 0 | 52 | 5 |
91-150 D | 50 | 0 | 80 | 0 | 430 | 0 |
151 D + | 0 | 120 | 0 | 0 | 700 | 0 |
& would like to present
Inner filled circle will be show 31-60 days and as per the warehouse volume the shape will expand, similarly second circle will represent 61-90 days volume
Jul 15 2021 05:20 AM - edited Jul 15 2021 05:29 AM
Hi @nitin18
I try to make some charts/visualizations on your data. Hope you will like these.
I create these charts (Sankey, Treemap and CrossTab) with few clicks.
If meets your requirements you can find these and help is self explanatory.
Data Visualizations For Excel & Office 365
Data Visualizations For Google Sheets
I hope justify your question. Thanks