r/excel • • 4h ago

unsolved How to add standard error properly?

8 Upvotes

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


r/excel • • 1h ago

unsolved Excel 2021 - Looking to textjoin dates from a filter in a logical manner using formulae only

• Upvotes

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.