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

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Topics Covered In Video:
1. Column Charts
2. Format Chart Elements
3. Add or delete Chart Elements
4. Link Chart labels to cells using the F2 key and the equal sign
5. Adjust Charts
6. Bar Chart
7. Pie Chart
8. Line Chart
9. Two Charts in One (Change Chart Type)
10. X-Y Scatter Chart Graph
11. Sparklines -- Cell Charts
12. Change Chart Location
13. Open Format Chart Element keyboard = Ctrl + 1
14. After Chart Label selected, to jump cursor to formula bar keyboard = F2
15. Create Default Chart on Sheet keyboard = Alt + F1
16. Create Default Chart on New Sheet keyboard = F11

Category:

Education

Tags:

• Office
• 2010
• Mike
• Gel
• Girvin
• excelisfun
• Highline
• Community
• College
• Busn
• 216
• Computer
• Applications
• Class
• Excel
• Chart
• Column
• Bar
• Pie
• Line
• X-Y
• Scatter
• Sparklines
• --
• Cell
• Charts
• Format
• Elements
• Add
• or
• delete
• Link
• labels
• to
• cells
• using
• the
• F2
• key
• and
• equal
• sign

[MistahLaiLai]

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

[ExcelIsFun]

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

[thestarmoon7]

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

[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.

[RageChanTheYaoiFan]

how do you make a column in between 2 other columns? D:

Insert a new row between rows 5 and 6. Enter Dallas in cell A6, 105985.12 in cell B6, 98674.38 in cell C6, 100548.22 in D6, and 106222.17 in E6. Copy the function in cell F5 down to cell F6 to sum the values in the new row.

please help.

[ExcelIsFun]

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

[thestarmoon7]

@ExcelIsFun thankz

[STruitt1020]

Thank you do much! I was doing a project for my college class and could not figure out what to do for the pie charts!

[ExcelIsFun]

I am glad that the video helped!

[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.