My data looks like this:
Date | Batch Number | Total Downtime | Down For Cleaning | Down For Part Change | Down For Maintenance | Down For Transportation |
---|---|---|---|---|---|---|
Sept 1 | 1111 | 5 | 0 | 4 | 1 | 0 |
Sept 2 | 2222 | 7.5 | 1 | 0 | 6 | 0.5 |
Sept 3 | 3333 | 1 | 0.5 | 0.25 | 0.25 | 0 |
Sept 3 | 4444 | 4 | 0 | 2 | 1 | 1 |
I want to create a stacked 100% bar chart to display the breakdown % out of the total downtime by batch or by date. How can I do this?