Excel Basics 24: Excel Charts & Graphs to Visualize Quantitative Data. No Chart Junk!!!

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin. Download Excel Start & Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB24Charts.xlsm Download Full Written Notes: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Office2016Class36-ExcelBasics24Charts.pdf Class web page link: https://people.highline.edu/mgirvin/AllClasses/216v2016/Content/04Excel/Excel2016.htm Topics in this Video: 1. (00:01) Introduction to Excel Charts & Graphs 2. (02:46) Excel Chart Terminology 3. (04:00) What is Chart Junk? 4. (05:35) Column and Bar Charts for comparing numbers across categories 5. (11:35) Formatting Chart Elements with Buttons or Task Pane 6. (15:25) Cross Tabulated Reports and Clustered & Stacked Column Charts 7. (18:15) Pie Charts less effective than Column or Bar Charts 8. (19:19) Line Charts to show trends or patterns over time 9. (24:25) Select Data Source dialog box 10. (25:45) X Y Scatter Charts for X Y Data to show a Relationship between Two Numbers 11. (31:05) Recommended Charts 12. (33:11) Summary