Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

mrpbennett

macrumors newbie
Original poster
Jan 9, 2015
13
2
London
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
 

campyguy

macrumors 68040
Mar 21, 2014
3,413
957
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.
 

Attachments

  • 1.png
    1.png
    335.7 KB · Views: 9,528
  • 2.png
    2.png
    281.8 KB · Views: 5,483
  • 3.png
    3.png
    297.9 KB · Views: 4,886
  • 4.png
    4.png
    466.8 KB · Views: 4,867
  • 5.png
    5.png
    400.8 KB · Views: 4,943
  • 6.png
    6.png
    469.3 KB · Views: 4,759
  • 7.png
    7.png
    530.4 KB · Views: 4,814
  • Like
Reactions: Beachguy

mrpbennett

macrumors newbie
Original poster
Jan 9, 2015
13
2
London
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! :)
 
Last edited:
  • Like
Reactions: Beachguy

campyguy

macrumors 68040
Mar 21, 2014
3,413
957
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! :)
Glad I could help. I'll take you up on a virtual pint of Guinness - my meal of choice, if you please?!
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.