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