Hi All, I am trying to use the below table to plot a two lines graph in excel. The first set of data is using number of cases in a day that is open and the second set of data using number of cases closed in a day.
Example 01-02-2023 has two cases that are opened and one case close on 01-02-2023.
I am not sure whether excel can count the number of cases in a day and plot it in a line chart.
So my graph will shows cases opened and closed in two lines.
Can anyone help me?
Thank you.
Example 01-02-2023 has two cases that are opened and one case close on 01-02-2023.
I am not sure whether excel can count the number of cases in a day and plot it in a line chart.
So my graph will shows cases opened and closed in two lines.
Can anyone help me?
Thank you.