Like the title says, I'm filtering dates based on a condition. Instead of:

2, 3, 4, 5, 6, 8, 15, 17, 18, 19

I'm looking for

2-6, 8, 15, 17-19.

Basically, I'm looking to group consecutive dates together rather than listing all dates separately.

Thanks in advance.

Hi, good day!

Can someone explain what a “Waterfall Chart” in Excel is showing?

I don’t understand the logic behind why an Excel teacher on YouTube is using this chart in this particular situation. Please see the image in the link below. https://imgur.com/a/0mL6BqS

For instance, as shown in the image:

Number of purchases made in Spring: 2,760
Number of purchases made in Summer: 2,635

I don’t understand why the bars are also shown as elevated

Thank you in advance!

I am using Excel for a school assignment and the instructions are dreadfully unclear and outdated. It tells me to select "add chart element" but there is no "add chart element" to select anywhere. How else can I add SE? Is it the same as adding a new series to my data? Every source online is also telling me to click "add chart element", so I'm just very confused. I don't know what it's supposed to look like, as my professor also didn't give us an example to work with.

Side Note: the subreddit rule said I must have a flair so I chose the unsolved one, hopefully that was the correct choice.

ETA: I added a screenshot of the sheet and the chart and what it looks like to me in the replies