Hi Everyone,
I have 12 products being sold by 4 different methods
I would like to know the best chart use to show the sales of each product per month and by what method over the course of a year
Any help greatly appreciated
Kevin
Hi Everyone,
I have 12 products being sold by 4 different methods
I would like to know the best chart use to show the sales of each product per month and by what method over the course of a year
Any help greatly appreciated
Kevin
Hi Kevin,
Please refer attachment.
You will need to make this for 12 products. Cell C12 can be used to change product and method.
Hope this help.
Thank you.
Sorry for off-topic interjection:
Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.
I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.
Thanks again for all your hard work here!
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.
Hi Ishwarind,
Thank you for your help.
I am not sure that I explained myself fully in the OP, I am trying to show all products and all methods on one chart.
Kevin
Hi AliGW,
Can you please convey how to provide the code without providing attachment?
Not sure how to mention code?
Thank you.
Kevin,
That would be really complicated to read.
Copy the code into your post and put code tags round it using the # button. However, what is more important us that you EXPLAIN the solution you have offered. Thanks.
Thanks AliGW.
Like below:
#Sub Pivot#
Maybe a Pivot Chart is what you need. See attached for the idea.
While very powerful and configurable the only downside with the Pivot Chart is that you will need to manually refresh the Chart when the data change.
This could be automated with VBA, but a quick click on the Ribbon Menu > Data > Refresh All will do it or keyboard shortcut Alt > A > R > then "A" or "R"
Another option is to use dynamic interactive charts that lets the user select which series of data to plot.
Plenty of help on the topic i avilable with a search on Dynamic Charts.
Here is one link to get you started: John Peltier - Interactive Charting by Combo Box or Checkbox
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Thank you all for your help!
Kevin
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks