Review Of Chart Basics For Excel 2013
by
Video Lecture 41 of 50
Not yet rated
Views: 786

### Lecture Description

This video was previously released at YouTube with the title:
Office 2013 Class #43: Excel 2013 Charts: Column, Bar, Pie, Line, X Y Scatter, Sparklines, Recommended
For the Highline Excel Class, we must review the basics before we can go on to more advanced Charting tricks.

Topics in this video:
1. What do Charts do? (00:50 min)
Visually portray Quantitative data (number data).
Give a quick impression of the number data.
Create a picture that can communicate more quickly than just the numbers alone.
Charts allow you to see patterns or trends that you may not be able to see if you are looking at just the number data.
2. Chart elements (02:09 min)
3. Effective charts (04:09 min):
Number data AND labels for the number data
No "Chart Junk"
4. Column Charts (06:18 min)
5. Change Chart Titles (08:08 min)
6. Link Labels to Cells (08:48 min)
7. Formatting Charts with Icons next to chart and with Task Panes (10:26 min)
8. Copy Charts (16:05 min)
9. Change Chart Type (16:50 min)
10. Bar Charts (17:12 min)
11. Switch axes labels (18:28 min)
12. Stacked Column Charts (18:51 min)
13. Stacked Bar Charts (19:49 min)
14. Pie Charts(20:15 min)
15. Line Charts (22:22 min)
16. BIG KEY: If the chart does not come out right: Select Data button (25:25 min)
17. X-Y Scatter Charts (30:10 min)
18. Sparklines Cell Charts (35:15 min)
19. Get Stock Data From Yahoo and Create Sparkline (36:52 min)
20. Recommended Charts (40:28 min)
21. Summary of all charts (42:52 min)

### Course Description

This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. It contains 50 video lectures teaching the basics of Excel, as well as advanced concepts.

Be sure to download the workbook to follow along with the examples. They are found on the official course website.