+ Reply to Thread
Results 1 to 10 of 10

Which Chart

  1. #1
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Which Chart

    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

  2. #2
    Registered User
    Join Date
    08-06-2014
    Location
    Pune, India
    MS-Off Ver
    2010
    Posts
    84

    Re: Which Chart

    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.
    Attached Files Attached Files

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Which Chart

    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.

  4. #4
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: Which Chart

    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

  5. #5
    Registered User
    Join Date
    08-06-2014
    Location
    Pune, India
    MS-Off Ver
    2010
    Posts
    84

    Re: Which Chart

    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.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Which Chart

    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.

  7. #7
    Registered User
    Join Date
    08-06-2014
    Location
    Pune, India
    MS-Off Ver
    2010
    Posts
    84

    Re: Which Chart

    Thanks AliGW.
    Like below:
    #Sub Pivot#

  8. #8
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Which Chart

    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
    Attached Files Attached Files
    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.

  9. #9
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: Which Chart

    Thank you all for your help!

    Kevin

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Which Chart

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 01-07-2015, 01:22 PM
  2. Chart order in trad. Pivot Chart vs. PowerPivot chart
    By mr_jules in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-06-2015, 11:17 AM
  3. Replies: 5
    Last Post: 12-05-2012, 12:07 PM
  4. Replies: 1
    Last Post: 07-14-2012, 11:46 AM
  5. Replies: 5
    Last Post: 08-08-2011, 02:09 PM
  6. can we combine line chart and colum chart in one chart
    By reedzhou in forum Excel General
    Replies: 1
    Last Post: 06-20-2011, 10:03 PM
  7. [SOLVED] Cannot Activate Chart Area in Chart. Chart Object Failed
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2006, 09:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1