Creating a Combination Chart in Excel 2007

[fdd796]

Dude you sound gay as fuck, man up let your nuts drop.

[naser72100]

مفيد جدا وجزاكم الله عير علي ما قدمتم

[blais1904]

Thanks bro good stuff!

[1djbh]

thank you sooo much



[maay786]

thanks alot.....it helped me a lot

[GillJattzProduction]

thax

[PlacidCat89]

excellent

[gonnasaynoha]

my question is that when I want to do one X variable versus 3 sets of Y variables, something similiar to what this author is doing, my 1st set of y values are correct, but then my 2nd and 3rd set of y values are higher than what the actual values are. Looks to me like the excel is doing something cumulative. Note that I do not want to make a secondary axis-I want all 3 sets of Y data on the same scale, same axis. So I'm so confused about this for a long time if anyone can help me with that?

[mlausen]

This is a life saver - Thank you so much - had to do a comparison on populations nationally and then with a zip code looking for trends. Great information and trick

[TehiZeno]

thanks you helped me with my assignment

[yomiotebolaku]

Cant thank you enough.



[andyvancouver2000]

Thanks for the good tutorial. Is there anyway to save the custom style under CHART STYLES? NOT as a template. Template changes the axis information and the formula, I just need to save the colors that I defined.

[mutlubasdas]

thanks sooooooooo much.. saved my ass!

[GreatAmericanMoneyTV]

This is a reeeeally cool video. Why can't I find you on Excelville? With skills like that, you should be getting paid!

[Showyourself2730]

Thank you for uploading these tutorials, Matthew. They are very helpful.

[TheMonggaila]

thanks. this was very helpful!

[Coollony]

my god your voice is annoying..

[Coollony]

my god your voice is annoying..

[babibump]

thanks!! that was so easy

[02bendud]

don't like it.

[denstacks]

thanks that was great

[Whelano92]

thank you so much

[yordanos248090]

Thanks Matthew!

[bchaitu]

Thanks so much !! You're awesome ^^

Could you also please explain how to combine two histograms. e.g. I have data sets of number of fish fin-rays of the years 2007 and 08. I have already made separate histograms for these two years, but I want to show both the data sets in the same graph.

I would appreciate your help !! Thanks anyway

[coolvalek]

Thanks for the explanation

[garilou2]

Another example of how bad Office 2007 was redesigned.

It's worst than Vista compared to Windows 7. Although I've had my Office 2007 for months, I kept working on my old Office 2003 on my old XP computer. Once I though I understood Excel 2007 well enough, with those impossible ribbons, I moved my stuff to 2007.... until I had to make a column line Chart that I used to be able to do in 2 to 5 seconds.

What a spoil of brilliant programmers! At least thye have not (yet) touched to my Excel VBA!

[yllucs618]

thanks for this video! great help! this is exactly what i was looking for! this is one of the default types in the older ver of excel but is quite hidden in ver 2007.

[hugostyles]

is this possible, i want to create a graph with x&y values. and have two or more gradient lines in the graph. but i want to enter each line (gradient) with an xy start point, and an xy end point. for eg:- line A would have start point 0,0 end point 10,0.

B start 0,0 end 0,5.

C start 10,0 end 10,5.

D start 0,5 end 10,5

is it possible to have that graph in excel?

[phoonjzc]

@hugostyles

I need to know too. Can anyone teach me?

[tombstoner79]

Thanks. Now I will pass my assignment!

[dobrydmais]

Folks,

How cold I create a chart with two lines showing two different pre-calculated set of values for the temperature (inverted relationship. First will range from 35 to -31.05 and the second from 37 to -34.54 oC) according to the altitude (which ranges from 0-8000m) ?

Thanks,

[dobrydmais]

Sorted guys. The problem was the type of chart. I was using lines instead of scatter.

Cheers

[alfredokijr]

great! thanks! =p

[vds86]

Thank you so much! It's exactly what I was looking for!

[Underxman]

thanks

[Defensed]

omg THANK YOU SO MUCH!!!!!!!!! I had to do a geo assignment this is EXACTLY what i was looking for!!!! even google doesnt have this!!!!!!!!!! thANKSSSSSSSSSSSSSS!!!

[tirathmistry]

Awesome tutorial

Nice step by step explanation

really this video very helpful for me

Thanks So much

Please upload more tutorial

God Bless :-)

[HughJason]

Thank very much for this. I've been trying to work out how to do it for ages.

[kullomats]

thanks for the useful information!

[pukhtunzalmay]

Can explain it you how Pissed off i was when i was dealing with 3 variable and was unable to chart the data. ur video with a click to secondary has did exactly what i wanted... Thanks mate!!! Good one

[ahmed267]

thank you so much, that's realy helped.

[sahilk6]

thank you, needed it for my project :)

[talentokie]

Thank you much!!

[kle8309]

thanks

[e219321195]

Thank you for this. Great tip.

[chingadamadre2006]

so interesting

Thank you so much

[MissingManuals]

alas, no, Patrik. just a few excerpts are video, though we're working on making more!

[PatriksTube]

That's the way to learn! Thank you. Is your whole "missing manual" a video tutorial?

[LOLHI12345678]

lol

[Romesh0001]

interesting... so I see for the first time I have become the first one to post a comment on this video, and this has been seen rougly 1005 times!!!!!