Office 2010 Class #33: Excel Charts: Column, Bar, Pie, Line, X-Y Scatter, Sparklines Formatting

[@excelisfun]

Yes, if you start this series at #1 and work your way through, it has quite a lot of useful Excel stuff.

[@excelisfun]

I am glad that the videos are of use to you!

[@excelisfun]

@thestarmoon7 , yes, but you would have to make a formula to convert the numbers to percents and then plot the percentages. The relationship between the column heights will be the same.

[@excelisfun]

I am glad you like it! And yes, not getting paid enough!

[@BellaLucia2009]

I am trying to prep for a job interview and charting would be huge responsibility of the job. Your tutorial is very thorough. Thank you for putting this online.

[@excelisfun]

I am glad that you like it!

[@excelisfun]

I am glad that the video helped!

[@kylewelfare8362]

Your videos are fantastic! As someone trying to make a career transition into accounting, these videos have been amazingly helpful in learning all about excel. I thought I knew the program pretty well, but I was wrong, so thank you

[@wvoider09]

This guy still rocks these videos! Needed a refresher and found it right here. Thank you so much!

[@excelisfun]

You are welcome!

[@excelisfun]

I am glad that the videos help!

[@rabbiltube]

Thank you so much for your tutorials! I teach Excel classes at my job and refer staff to your videos / resources for continual learning...I watch your vids for fun / refresh! Excel-lent delivery btw! (Was awesome to see you and Bill-Mr. Excel- collab also)

[@excelisfun]

Try: Chat Tools Layout ribbon, Labels group, Chart Title, "Above Chart" (instead of "Center Overlay Title").

[@excelisfun]

Right-click EXCEL ROW HEADER 5, point to Insert.

[@excelisfun]

@MistahLaiLai , right-click the line, Format, Line Color

[@darkmanunknown]

I'm blown away! Learning so much! Thanks!

[@gouthambothra]

Wish I could have learnt these tools years ago.. would have been a life saver.. Keep the good work on.. :)

[@johnwallen7985]

Great work! Your not getting paid enough!

[@jrei7448]

Where can we post question for you and get answers? Your vids are by far the best out there for excel armatures like me.

[@Zakir96024]

Many thanks for posting such a nice stuff. It really helps. I'm following class #33 (charts) and not able to locate the relevant excel file for practice. Kindly advise the link.

[@TheThirdEye2010]

Excellent tutorial!!

[@kk0071990]

Really gd video. U explained very well, gd examples too, thanks a lot

[@excelisfun]

I do not know how to do that. Sorry.

[@TheWld113]

Great video and thank you !

[@yellowsunshine65]

3D pie charts are useful for the marketing people specially when they want to compare 2 products, since the front part seems bigger, it serves to their exaggerated proposal.

[@Babykhanti88]

Hi thank you for your videos, btw how to make the chart in row has the 50,000 100,000 150,000 and 200,000 as it is different with the chart in column has 20,000 40,0000, to 200,000

[@eliasherrera1224]

Hello I was wondering how to add vertical lines that correspond to the x-axis on a scatter X-Y graph and how to have more values of x i have about 5 I need 15 for accuracy

[@pancakefactoryxl]

Hello, I'm trying to enter data labels on the points of an XY scatterplot. However, the only options that are listed for names are the coordinates (x,y) and the series name. Do you know how I could program the correct names into the scatterplot? Thanks a lot.

[@aryesegal1988]

Thank you, a lot! :) Wish i had your knowledge... BTW, i wanted to know, is it possible for me to make an animated (interactive?) chart in excel, and then export it to PDF so it'll still be interactive in the PDF file? For example, when you added the data labels @ 17:00, i want that when the user will hover over the points with the mouse, the values will appear... is such a thing even possible, or am i pipe dreaming too much? lol ;) thanks for all the assistance! :)

[@manjirit]

I downloaded the file from the link you gave but couldn't find the exercise for the charts in that file. Where exactly in the file should I look for the charts exercises?

[@emran.t.n]

that's all what i was looking for ...... thanks :)

[@excelisfun]

+Emran Al tahhan You are welcome!

[@thestarmoon7]

can i ask one thing using the column bar chart it is possible to have the result in percentages?

[@aryesegal1988]

Never mind, thanks anyhow... i'll google it once i'll have some time :) i subbed, looking forward to more videos! :)

[@waksibra]

how did u make the "windsport summer sales" bar so long? please help.

[@ok-warren]

How can you change the color of the lines in the line graph?

[@priya1119]

how can i add data labels to each data point in the xy scatter?

[@excelisfun]

highline.edu/mgirvin/excelisfun.htm

[@endsakurayang3346]

very helpful

[@thishealthyhaven]

Thank you very much! :)

[@thestarmoon7]

@ExcelIsFun thankz

[@TheSugarplum770]

Label cell reference didn't make much sense. Could you please use an easier example first? Thank you sir

[@h4hashir]

LMAO at 12:40

[@nathaniel6677]

nice tutorial, way too long tho

[@conanbjw6767]

chart junk lol

[@excelisfun]

That is an Official Term from THE Chart Master, Edward Tufte!!

[@conanbjw6767]

HAHA I thought you invented that. Relly hilarious :)

[@excelisfun]

I am glad that you like it!

[@excelisfun]

You are welcome!

[@excelisfun]

You are welcome!