Tracking frequency of an item across dates

Occasional Visitor

I have created a basic domestic expense tracker wherein I input some basic info about a purchase such as date, category, subcategory, item, quantity and cost. I want to create a chart to show when I bought a given item in my domestic expense tracker across a given month with the quantity being shown for  each purchase. Is there a way to do it?

1 Reply


There are many ways to do something with Excel, sometimes more than you would like But without data or files it is difficult to follow a thought / fantasy of another or to show what he wants to accomplish.


With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

* Knowing the Excel version and operating system would also be an advantage.



Thank you for your understanding and patience




I know I don't know anything (Socrates)