Hi guys,
I am trying to make a sales history for the past 3 years and I will make a graph of each item so I can identify what month we have low sales and high sales and so I can compare what stock level I should used every 3 months. Like I can estimate how much product we are selling that month and it will notify me if the stock goes lower and we need to restock.
Attached is my sample excel
Last edited by DEEZA; 08-19-2017 at 04:15 AM.
Welcome to the forum!
You need to explain what your expected outcomes are.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Oooh, Im sorry. :D
I want to have a graph that has different color per year like jan 2015 to dec 2015 is color red, jan to dec 2016 is color blue and jan to dec 2017 is color green.
I've tried that but what I get was only same color.
in spreadsheet the month should be side by side like Jan 2015| jan2016| jan2017| then so on...then in the next tab is should be the graph per item, so I assume I need to make 600+ graphs since I have 600+ items . What I want to have in graph is how much items we sold per month so that I can compare and know when to restock our item.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks