Highline Excel 2016 Class 15: Excel Charts to Visualize Data: Comprehensive Lesson 11 Chart Examples
Economy | Information | History | Online | Facts | World | Global | Money
Download Files: https://people.highline.edu/mgirvin/AllClasses/218_2016/218Excel2016.htm In this video learn about: (00:28) Define Charts. What do Charts do? (01:12) Effective Charts: No Chart Junk. Example of Chart Junk. (02:54) Types of Charts: 11 different chart types. (06:55) Terminology for Chart Elements: 1. (08:15) Column Charts 2. (12:15) Bar Charts 3. (13:41) Pie Charts 4. (14:25) Stacked Column Charts 5. (14:25) Clustered Column Charts 6. (17:44) Histogram. Two Examples: 1) Retail Sales Data Histogram with FREQUENCY Array Function. 2) Count Web Transactions by Hour with PivotTable. 7. (28:45) Line Charts. Time Series Chart. 8. (31:54) X-Y Scatter for Sample Data. 9. (34:45) Break Even Chart X-Y Scatter 10. (46:05) Combo Charts 11. (47:30) Bubble Chart (51:19) Summary
Comments
-
There is a problem with the answer sheet of this file.The data does not match in the answer sheet of HW-4. Please look into it and update. I have been braking my head on this for couple of hours.
-
All of your videos are excellent!
Most recently, I have been watching the Highline videos and all are excellent.
You make complicated steps easy to understand.
Thanks -
Excellent, Thank you!
-
Dude, youre the most interesting person on Youtube. I t would take a regular person about a month to create such file and youre banging them out one after another
-
Excellent video as usual!. Thank you! Have you tried creating a Bullet chart for yourself?
-
How to highlight the column ? Because when I am trying to copy the frequency formula to other columns I have to manually drag the formula down, and also because if this the frequency is not properly being calculated to other columns. I am using Excel 2010
Please let me know the solution.
Thanks -
I have been following your videos for quite a while now and must say they are straight to the point and very useful. Congrats.
-
Hi
-
BEU point was fun :)
-
Thanks Mike For the very useful Video.
-
Simply Awesome
-
This is not the power of spreadsheet, but it is the power of the man how can utilize the program, and help others to understand it, usually I have to rewind the video many times to enjoy and understand the lesson, thank you Mr Excel Magic (Mike), it's not a compliment it's the real.
-
Intervals should probably not be treated in the same manner as categories. Using different colours to represent the same metric over time may encourage us to waste time looking for meaning in the different coloured bars when there is none. Another example of chart junk is the border.
-
Fabulas video thanks a million Mike
52m 27sLenght
195Rating