Line graph showing records received by date

%3CLINGO-SUB%20id%3D%22lingo-sub-1552975%22%20slang%3D%22en-US%22%3ELine%20graph%20showing%20records%20received%20by%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1552975%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20got%20a%20spreadsheet%20with%20400%20odd%20bookings%2C%20one%20row%20per%20delegate.%20Columns%20have%20different%20pieces%20of%20data%20collected%20during%20their%20registration.%20One%20column%20is%20'date%20received'%3C%2FP%3E%3CP%3EI'd%20like%20to%20have%20a%20line%20graph%20showing%20the%20booking%20cycle%2C%20so%20there'd%20be%20spikes%20on%20a%20day%20when%20we%20received%20lots%2C%20for%20example.%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20create%20a%20table%20on%20which%20to%20base%20this%20graph%2C%20counting%20the%20number%20of%20bookings%3A%20(the%20date%20being%20in%20column%20S%20in%20the%20Data%20tab%2C%20and%20the%20actual%20cell%20contains%20the%20date%20and%20the%20time%2C%20so%20I've%20put%20in%20an%20asterisk%20to%20allow%20for%20the%20various%20time%20values.%3C%2FP%3E%3CP%3E%3CFONT%3E%3DCOUNTIF(Data!S2%3AS5000%2C%2208%2F07%2F2020*%22)%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EIt's%20bringing%20up%200.%20Not%20sure%20where%20I've%20gone%20wrong%2C%20or%20if%20I'm%20overcomplicating%20it%3F%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3EI've%20also%20tried%20just%20selecting%20column%20S%20and%20making%20a%20line%20graph%20(and%20switching%20x%20and%20y%20so%20that%20date%20lies%20along%20the%20bottom)%2C%20but%20it%20tells%20me%20the%20maximum%20is%20255.%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1552975%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1553006%22%20slang%3D%22en-US%22%3ERe%3A%20Line%20graph%20showing%20records%20received%20by%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1553006%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F743555%22%20target%3D%22_blank%22%3E%40Karenaki%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20don't%20you%20try%20Pivot%20Chart%20instead%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1552996%22%20slang%3D%22en-US%22%3ERE%3A%20Line%20graph%20showing%20records%20received%20by%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1552996%22%20slang%3D%22en-US%22%3EIn%20the%20line%20graph%20I%20tried%20(bottom%20of%20post)%20it's%20showing%20grwoth%20of%20bookings%20(so%20ends%20up%20with%20400%2B)%20rather%20than%20counting%20the%20number%20of%20entries%20on%20each%20date%2C%20which%20is%20why%20it%20wouldn't%20let%20me%20swith%20axes%2C%20as%20400%20is%20more%20than%20255....%3C%2FLINGO-BODY%3E
New Contributor

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

Hi @Karenaki 

 

Why don't you try Pivot Chart instead?

 

Cheers

@wumoladI haven't used one of those before? Any tips? 

@Karenaki , if possible, can you share a sample with any confidential info removed? 

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