How to plot a graph using open/close cases in a day

[razon98]

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.

 

[James006]

Hi,
For Open-High-Low-Close charts, take a look at :

Microsoft Excel Stock Charts - Peltier Tech

Microsoft Excel offers a variety of charts to plot stock prices over time. This tutorial describes these, and shows techniques to enhance stock charts.

peltiertech.com