Combo Charts in Excel Preview 2016 Mac

Discussion in 'Mac Apps and Mac App Store' started by mrpbennett, Aug 6, 2015.

  1. mrpbennett macrumors newbie

    mrpbennett

    Joined:
    Jan 9, 2015
    Location:
    London
    #1
    Does anyone know how to do them...if they can be done..

    or if I'm going to have to pull all my hair out
     
  2. campyguy macrumors 68030

    Joined:
    Mar 21, 2014
    Location:
    Portland / Seattle
    #2
    Although it’s been called a “combination chart” for years, IMHO what you’re wanting to achieve is “layering” a second or multiple set(s) of data within a Chart “region” - to me, a Combo chart is really a comparative, relational method to overlay one set of data over another. Now, on to what you're likely looking for?! Screenshot pics attached, I used one of the "canned" templates to tweak as an example...
    • Set up a Chart as you normally would, in 2D (not 3D) with two data sets - the (1) axis labels and the (2) data to be plotted (using a Bar Chart as an example).
    • From the Data Menu, choose the Add Data Command and you’ll get the relevant Dialog Box.
    • Add data by either entering it manually or using the “Choose” option by clicking on the small icon in the Add Data Field within the Dialog Box. One can add additional data by holding down the Command Key if you’re using the Choose option; I chose only one group of data for simplicity.
    • Excel will present a second set of graphed items in a similar format to the original graphed items; change the formatting of either data set by clicking on the data set you want to change, and change its graph type - here, I chose to graph the added data into a line.
    • I then formatted the second Data Series by adding a secondary axis. Additional formatting can be added by adding a Data Label then formatting the label(s) to suit your preferences.
     

    Attached Files:

    • 1.png
      1.png
      File size:
      335.7 KB
      Views:
      2,756
    • 2.png
      2.png
      File size:
      281.8 KB
      Views:
      2,706
    • 3.png
      3.png
      File size:
      297.9 KB
      Views:
      2,557
    • 4.png
      4.png
      File size:
      466.8 KB
      Views:
      2,569
    • 5.png
      5.png
      File size:
      400.8 KB
      Views:
      2,554
    • 6.png
      6.png
      File size:
      469.3 KB
      Views:
      2,523
    • 7.png
      7.png
      File size:
      530.4 KB
      Views:
      2,542
  3. mrpbennett, Aug 6, 2015
    Last edited: Aug 7, 2015

    mrpbennett thread starter macrumors newbie

    mrpbennett

    Joined:
    Jan 9, 2015
    Location:
    London
    #3
    Thanks Dude this looks like just what i need. I am going to try this tomorrow and let you know how i get on.

    --

    THANK YOU, THANK YOU, THANK YOU!!
    You Sir have saved me so much time and effort! I am buying you a virtual beer! :)
     
  4. campyguy macrumors 68030

    Joined:
    Mar 21, 2014
    Location:
    Portland / Seattle
    #4
    Glad I could help. I'll take you up on a virtual pint of Guinness - my meal of choice, if you please?!
     

Share This Page