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 g...
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.