Great help at quickly unraveling the complicated/buried interface that Excel 2007/10 has forced upon us, but one tiny little nit to pick...
Rather than using a LINE chart for the years of service data series, I would tend to use a X/Y scatter type, because the years of service data points aren't really RELATED to each employee's sales volume performance.
Use of a line chart would be more appropriate for common data points that would create a trend-line, but the X/YScatter isolates each person.
You are fantastic, rrphillips. I needed this for a job interview tomorrow that was ppt focused and I had been searching all day to know how to do this.
You did not only explain it, you showed it visually. Fantastic!
Thank you so much rrphillips!!! This really helped me with my science project that is based out of Microsoft Excel 2003, but I have 2007. Great Job!!!
Thank You! Leave it to Microsoft to take something that at one point in time was very simple and make it very complicated. This was a very helpful video and I really appreciate you taking the time to create it for all of us.
I wish the bars were not layered top of each other after you do the dual axis. That is annoying... I'm struggling to get them to not be overlapped, but have the bars in the order I want them in.
In my 2 years of being a senior software instructor for New Horizons, I can't count the number of people to whom I have said "I'm sorry, it can't be done in 2007"... nor the hours spent trying. You are a genius!
Great help at quickly unraveling the complicated/buried interface that Excel 2007/10 has forced upon us, but one tiny little nit to pick...
Rather than using a LINE chart for the years of service data series, I would tend to use a X/Y scatter type, because the years of service data points aren't really RELATED to each employee's sales volume performance.
Use of a line chart would be more appropriate for common data points that would create a trend-line, but the X/YScatter isolates each person.
Bass91377 1 week ago
Many Thanks for the Video. It is really helpful in creating a column and line in the same chart
ravikanama 3 weeks ago
THANK YOU
Khaledshowe 2 months ago
You just did what I have been trying to do for ages, THANK YOU!
Ultraslisk 2 months ago
oh my gosh thanks so much this really helped me sooooooooooooooooooooo thankful you are good at explaining to.
Yulia2875 2 months ago
This has been flagged as spam show
Yes, you can add more than 2 y-axes in Excel using Multy_Y or EZplot for Excel at OfficeExpander.
There is a nice demo version for users to try. Cheers.
MsWebreviewer 3 months ago
This was a great help. I guess Excel 2007 is 'progress" over 2003 in usability ;)
da001be 3 months ago
@da001be Great humorous comment - my productivity in 2007 has PLUMMETED, thanks to the "intuitive" nature of the (horrible) ribbon interface...
Bass91377 1 week ago
OMFG THANKS SOOOOOO MUCH!
harsh5559 3 months ago
This has been flagged as spam show
OMFG THANKS SOOOOOO MUCH!
harsh5559 3 months ago
OMFG THANKS SOOOOOO MUCH!
harsh5559 3 months ago
OMFG THANK YOU SOOOOO MUCH!
harsh5559 3 months ago
Nice this helped with my issue. Good demo
jsimpson1963 4 months ago
you're the best, thanks ;)
TheTalia819 4 months ago
you boss, thanks a bunch!
redbull2501 5 months ago
Uau... Very good! Thaks a lot!
Fasodre 5 months ago
thank you soo much! it helped me a lot! :D
shrrdvsvldz 6 months ago
brilliant help!
adinoz2000 6 months ago
Awesome explanation..Great tutorial! Thanks!
ojallday1 6 months ago
this is great easy and quick intro....thx
samoste 6 months ago
Thank you so much, i was on mac and i still managed to figure it out, thats how awesome you are.
Mrpoopypants5 8 months ago
Thanks! Just what I was looking for!
cpgmattr 8 months ago
OMG I LOVE YOU!!!!
gabymendiola1 9 months ago
very nice presentation :)
trueindian100 9 months ago
Thank You So Much, You saved me from having to go to school early to use the schools 2003 excel!!!
LalalandHerrera 9 months ago
Thanks a lot. You just saved me a lot of time.
sparrowlover0626 9 months ago
Excellent job. Very clear instructions. Thanks!!!!
AntsNYC 9 months ago
they fucking took the chart wizard out on mine
funnygrl409 9 months ago
@funnygrl409 nevermind
funnygrl409 9 months ago
Thank you for good presentation...
farpics 10 months ago
You are fantastic, rrphillips. I needed this for a job interview tomorrow that was ppt focused and I had been searching all day to know how to do this.
You did not only explain it, you showed it visually. Fantastic!
uknowamsaying 10 months ago
thank youuu so much! :)
x33LALAx 10 months ago
Thank you so much rrphillips!!! This really helped me with my science project that is based out of Microsoft Excel 2003, but I have 2007. Great Job!!!
Acuhing 1 year ago
This video just saved my life, job, sanity............... ok I'm exaggerating. But fair play Mr Philips for putting this up!!!!
gusryan100 1 year ago
Yo Do you wanna learn Excel like an expert?
go to this video.
/watch?v=FG3CboG8HVE
RattlerXA 1 year ago
Thnx for the help Henderson Nguyen is a stupid dumb ass who cant find this after i told him what to search
Neeroke 1 year ago
@Neeroke ROFL!!
Trowa71 1 year ago
you're a creep!!!!
ramkaos 1 year ago
nice work. its not as easy as you might think until you see how its done lol.
fogjinda 1 year ago
Thanks for sharing. Very useful!
mt61245 1 year ago
This has been flagged as spam show
Thank you very much.
Xxyter 1 year ago
Comment removed
Xxyter 1 year ago
Thank you so much, I used to be able to do this in 2003 but 2010 has be boggled. So thanks again.
naturally4life 1 year ago
thank you soooo much! :3
i would have been experiment all night with excel if i hadn't seen this video lol
FerretMunchkin 1 year ago
Thank you!
bluecow81 1 year ago
Super helpful thank you!
me9823 1 year ago
Thanks a lot!! This is a greatvideo!!
aeilerts 1 year ago
Really helpful, just what I was looking for! Thanks! :)
jacobras 1 year ago
Thank you...You saved me from losing marks in my assignment. great help!
r1u2m3b4l5e 1 year ago
Thank You! Leave it to Microsoft to take something that at one point in time was very simple and make it very complicated. This was a very helpful video and I really appreciate you taking the time to create it for all of us.
jonframpton 1 year ago
AAAAA finaly i know.. tnx!!
cickova13 1 year ago
Really, really helpful. Thanks
kalhossainy 1 year ago
good job man! I appreicate the help. Keep up the great work.
GR
garrisonroddey 1 year ago
I wish the bars were not layered top of each other after you do the dual axis. That is annoying... I'm struggling to get them to not be overlapped, but have the bars in the order I want them in.
tomprice494 1 year ago
You, Sir, are a steely-eyed missile man ;-)
Ossum!!!!
mossga 1 year ago
Thank you so much for this! Very well explained.
mandars77 1 year ago
champion !!
enarouz 1 year ago
Thank you!
F15pilots 1 year ago
Thanks - fantastic explanation just what I was looking for
Andrea sutherlandcomputers
myobcorres 1 year ago
DUDE ROCKS
yopops1 1 year ago
Thank you ! Super!
ditchblack 1 year ago
Thanks man, good video.
vstephan800 1 year ago
thank you so much! i spent 10 minutes in the help and it just confused me more. this was so great!
debbiewoelbling 1 year ago
thanks a lot. clear and great explanetion...
hannidoron 2 years ago
thanks so much this really helps me
themanisback18 2 years ago
Thank you very much.
BWNovus 2 years ago
Great, easy to follow video. Thanks!
bradmorgan911 2 years ago
Thanks a lot, that was very helpful to my works.
albertokkk 2 years ago
Thank you so much
prashanthreddyh 2 years ago
Thank you kind sir, you saved a college students ass today!
jozan23 2 years ago
THANK YOU!!
MiniDeath666 2 years ago
Thank you!
moeblaz 2 years ago
This has been flagged as spam show
AWESOMEE!!! Huge help - thanks!
paigeski 2 years ago
thank you so much!
swanyhanoi 2 years ago
you are the man
maebach 2 years ago
thank you so much!
tiffaanyy715xox 2 years ago
VERY GOOD!
Bubbafint 2 years ago
Thank you so much, this was extremely helpful! :)
aarnikotkuli 2 years ago
In my 2 years of being a senior software instructor for New Horizons, I can't count the number of people to whom I have said "I'm sorry, it can't be done in 2007"... nor the hours spent trying. You are a genius!
andreyman3d 2 years ago
Brilliant. Thanks.
Breizhetta 2 years ago
Thanks so much... this was one of the best things I have ever seen on You-Tube.
Balisier4 2 years ago
Problem with Excel 2007 is that you aren't able to make a 2 column 2 axis chart...
KillQuick3 2 years ago
This has been flagged as spam show
Nice try. Keep it up check out esteembpo + com for social media marketing. sdg
SadeTabitha 2 years ago
Extremely helpful - thank you!
SenoritaPanama 2 years ago
This saved my life!!! Thank you. I was worrying about what to do about my 2007, but now i can work with it!
fwd1111 2 years ago
this didnt work. I have the non commercial version.
callumisgreat 2 years ago
Aristocratic voice...cheers mate!
ShunmasBeeablo 2 years ago
That was extremely helpful! Thank you, I have been able to make a few graphs with secondary axis's thanks to this handy video.
yumsprinkles 2 years ago
Thank You So Much !
Kwansterr 2 years ago
This is so helpful for the visual learners like myself.
Thank you so much!
biggieshortie13 2 years ago
Thank you soooooooo much!!!!omg.
badmintonplayer08 2 years ago
hey thanks a bunch
you really helped =D
crazylil3mmy 2 years ago
You ROCK!
Thanks sooooooo much!
DiscoNaMbo 2 years ago
thanks a lot. this was really helpful
mike1346798520 2 years ago
you rock
maskedmuffinman 2 years ago 2
thank so much...^-^"
Reddersgirl 3 years ago
domo arigatou(thank you) now i can make one of those graphs for my science project
ichigoandhiyono 3 years ago
Dude!! awesome.. 2more beers from my side
- SD
saibaldutta 3 years ago
Thank you very much!
tanel189 3 years ago
DUDE! you are the man!
I owe you 2 beers!!
grunwami 3 years ago
thankss!!
orsivan86 3 years ago
thanks for the great video!! helped me out a ton!!
norr30 3 years ago
this helped me so much ty
lynic1 3 years ago
awesome thank you so much
Oscarak4707202 3 years ago
shut the fuck up! like being controlled? :) U
AdzOrz 3 years ago
omg u saved me
579093 3 years ago
thank you so much
07RamirezD 3 years ago
you are the man. uni assingment due tomrorow, and u just passed me, great stuff
nikdagrik 3 years ago
Thanks - very helpful.
jacbeef 3 years ago
Very helpful
ginolept 3 years ago
thank you very much. it is great
lostdino2 3 years ago
Thank you very very much man, you really helped me out - very smart man, thanks.
jabserrano 3 years ago
Thanks so much! I was looking for this!!! :D :D :D
admirerofnone 4 years ago
Thank you! This was so helpful!
spoonguy98 4 years ago