What type of chart would be best for displaying this data?

Question

EDIT: I don't mean in terms of how to implement it. i mean i dont like how the date is displayed with the bars. what other type of chart would be more suitable. I know a threadhold line wouldnt work beacause the values of the capacity are different for each day. if they were all the same a threadhold line indicating capacity would work

Answer 1

I think a line graph would be an excellent way to show the data.

I made that using the chart wizard. Link: here. I used the data you provided above, so it should be accurate unless I mistyped.

On the chart wizard, you can import this chart using the link I gave you above if you want to clean it up, add axes, etc.