Hey,
I want to be able to see any peaks in my selling trends via a graph (of some sort).
I have the date sold of each item and the quantity sold etc but I have no idea how to put this into a graph which best demonstrates how well I'm doing day on day.
Can any one help?
I've attached a sample data XLS which shows the data that I'm using.
Thank you in advance...
I think only you can determine what sort of graph gives you the representation you need. Just looking at the sample data, you have several sales transactions per day.
Looks like you might benefit from creating a Pivot Table and then graphing the dates you are interested in.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Lots of examples and help on charts can be found here
Beware of pie charts though, they do not always reflect reality well
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks