Hello I'm working with Excel 2010. I have a pivot table. I would like to chart events per day but unfortunately some dates had no event so the pivot table rather than returning a zero simply eliminates the date from the list. Is there a way that I can tell excel to keep the date in the list, but return a zero for count?
Thank you!
Thank you!
