I have uploaded the source file through which I am trying to achieve the below.
Number of cases OPENED on each day during the last 15 days
Number of cases CLOSED on each day during the last 15 days
Total Number of cases OPEN at the end of each day for the last 15 days
In a straight line chart I can show by date the cases Opened and closed with the correct overall totals
I can also show in bar chart form the cases Opened and Closed each day in the last 15 days
I can’t show the total cases which are open on any given day – the line graph only shows the number of cases opened each day not the running total of each day
Eg on April 30 it should be 5 opened – 2 closed = 3
So at the end of May 1 it should be 3 + 2 new cases opened = 7
on May 2 it should show 7 + 3 new cases opened = 10
on May 3 it should show 10 – 1 case closed = 9
on May 4 it should show 9 + 1 case opened – 1 case closed = 9
on May 5 it should show 9 + 1 cases opened – 1 case closed = 9
and then 9 cases open until the end of the month
Any idea how to show this – preferably all on the one chart – ie barchart for the opened and closed as below plus a line chart for the running total opened cases?
