Forum Discussion
Solved
Group dates by month and then chart
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:...
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.
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?
- 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
- Thanks very much