Forum Discussion
Line graph showing records received by date
I've got a spreadsheet with 400 odd bookings, one row per delegate. Columns have different pieces of data collected during their registration. One column is 'date received'
I'd like to have a line graph showing the booking cycle, so there'd be spikes on a day when we received lots, for example.
I'm trying to create a table on which to base this graph, counting the number of bookings: (the date being in column S in the Data tab, and the actual cell contains the date and the time, so I've put in an asterisk to allow for the various time values.
=COUNTIF(Data!S2:S5000,"08/07/2020*")
It's bringing up 0. Not sure where I've gone wrong, or if I'm overcomplicating it?
I've also tried just selecting column S and making a line graph (and switching x and y so that date lies along the bottom), but it tells me the maximum is 255.
6 Replies
Karenaki In conjunction with the link provided by wumolad , perhaps the attached (simplified) example can get you started into the right direction.
Col A:B contains the "data base" of delegates.
Next to it you'll find a pivot table counting the number of delegates per date.
The graph is a line chart based on the pivot table. When the pivot table changes (upon Refresh), the chart changes with it.
You can get some tutorials from this link:
https://support.microsoft.com/en-us/office/create-a-pivotchart-c1b1e057-6990-4c38-b52b-8255538e7b1c
Cheers
- In the line graph I tried (bottom of post) it's showing grwoth of bookings (so ends up with 400+) rather than counting the number of entries on each date, which is why it wouldn't let me swith axes, as 400 is more than 255....
