I'm pretty new to Excel and need to build a clustered chart for appointment resource data. Below is a snip of the data in the layout I have to work with. Each appointment type is provided from 5 minutes all the way to greater than 30 minutes. There should be a bar for each duration on each date it was used. Can someone please show me how to display this so each appointment duration appears as its own bar representing the daily total over each date it was used? The first screen shot shows the data set I have to work with. The second is the resulting chart I get. I can't seem to get the data to display correctly.
Just for clarity, 12/1/2020 shows 5 appointments... a single 10-minute appointment, 3 15-minute appts., and a single 20-minute appt. The Total column represents how many of that duration on that date. Thanks in advance.
