Group dates by month and then chart

[kirrwed]

I have a bunch of form entry dates exported that look something like:

4/29/2023 13:21

4/27/2023 1:55

4/20/2023 17:23

4/4/2023 14:50

3/5/2023 6:11

2/18/2023 19:34

2/2/2023 12:42

2/1/2023 8:08

12/4/2022 7:35

etc....

I want a bar chart to show form fills over time, but grouped by month. So eg. the bar would show April 23 with 4 entries, etc... How to do this?

[#2]

@kirrwed 

You could pivot the data and group by month/year and then chart:

[#3]

Thank you. Is there a way to have G, H, I columns generated? I have hundreds of entries so it would be impractical to do manually.

[#4]

You could table the source data and then source the pivot table from the table. All you'd have to do is refresh the pivot when new data comes. Are you looking to pull back G-H-I with a formula?

[#5]

No I want exactly how you have the chart above. But I didn't know how to automatically create the data from GHI that it looks like your chart is pulling from

[#6 · Accepted solution]

@kirrwed 

Try this (gif added below):

[#7]

Thanks very much

[#8]

You're welcome!