Graph for xaxis=date vs yaxis=number of cells



trying to use countif formula but since this is a running log I am trying to figure out how to continuously keep adding dates


Hello,
You could insert a Pivot Table ... and have your chart based on this recap ...
Hope this will help

Thanks Carim!
Can a pivot table be continuously updated?
I want the graph to always be updating with new logs


I'm not having luck... I'm new to pivot tables haha. trying to learn by watching videos.

figured it out thanks!

Happy to hear you are discovering Pivot Tables ...
Watch out ... because you are going to fall in love

Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!