Tracking frequency of an item across dates

%3CLINGO-SUB%20id%3D%22lingo-sub-2268665%22%20slang%3D%22en-US%22%3ETracking%20frequency%20of%20an%20item%20across%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2268665%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20basic%20domestic%20expense%20tracker%20wherein%20I%20input%20some%20basic%20info%20about%20a%20purchase%20such%20as%20date%2C%20category%2C%20subcategory%2C%20item%2C%20quantity%20and%20cost.%20I%20want%20to%20create%20a%20chart%20to%20show%20when%20I%20bought%20a%20given%20item%20in%20my%20domestic%20expense%20tracker%20across%20a%20given%20month%20with%20the%20quantity%20being%20shown%20for%26nbsp%3B%20each%20purchase.%20Is%20there%20a%20way%20to%20do%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2268665%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
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

@SiddharthGurjar 

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

 

 

Nikolino

I know I don't know anything (Socrates)