Core Charts
Core Charts
Purchase this course to access all lessons and start learning.
Already purchased? Log in
Quick start
| Video | Time |
|---|---|
| Save Video 1. How to create a basic Excel chart Watched | 3:10 |
| Save Video 2. Anatomy of an Excel chart 2016 Watched | 2:07 |
| Save Video 3. Standalone and embedded charts Watched | 2:01 |
| Save Video 4. How to change chart data Watched | 2:07 |
| Save Video 5. How to add and remove chart elements Watched | 2:40 |
| Save Video 6. How to change the chart type Watched | 2:04 |
Excel charting tools
| Video | Time |
|---|---|
| Save Video 7. Excel charting tools overview Watched | 3:31 |
| Save Video 8. Recommended charts Watched | 2:45 |
| Save Video 9. Chart icon controls Watched | 2:56 |
| Save Video 10. The Format Task pane Watched | 3:04 |
Core charting skills
| Video | Time |
|---|---|
| Save Video 11. Ways to create a chart Watched | 3:14 |
| Save Video 12. How to work with data series Watched | 2:42 |
| Save Video 13. Understanding data series Watched | 2:46 |
| Save Video 14. Chart elements and layouts Watched | 2:57 |
| Save Video 15. Selecting chart elements Watched | 3:13 |
| Save Video 16. Ways to filter data in a chart Watched | 3:29 |
| Save Video 17. How to filter chart data with a table filter Watched | 3:16 |
| Save Video 18. How to copy and resize charts Watched | 2:13 |
| Save Video 19. How to add and remove data series Watched | 2:38 |
| Save Video 20. How to use data labels Watched | 2:42 |
Chart formatting
| Video | Time |
|---|---|
| Save Video 21. How to apply font formatting to a chart Watched | 2:55 |
| Save Video 22. How to format chart and plot area Watched | 2:37 |
| Save Video 23. How to copy chart formatting Watched | 2:20 |
| Save Video 24. How to create and apply a chart template Watched | 2:12 |
| Save Video 25. Chart colors and styles Watched | 2:35 |
| Save Video 26. Charts and custom number formats Watched | 3:13 |
Chart axes
| Video | Time |
|---|---|
| Save Video 27. An introduction to chart axes Watched | 3:23 |
| Save Video 28. How to customize a value axis Watched | 3:08 |
| Save Video 29. How to customize a category axis Watched | 3:17 |
| Save Video 30. How to customize axis labels Watched | 3:06 |
| Save Video 31. How Excel plots dates on a chart axis Watched | 3:04 |
| Save Video 32. How to add a secondary axis to a chart Watched | 2:56 |
| Save Video 33. How to reverse a chart axis Watched | 3:06 |
| Save Video 34. How to create a multi level axis Watched | 3:36 |
Chart types
| Video | Time |
|---|---|
| Save Video 35. How to build a bar chart Watched | 3:23 |
| Save Video 36. How to build a line chart Watched | 2:48 |
| Save Video 37. How to build a column chart Watched | 3:22 |
| Save Video 38. How to build a pie chart Watched | 3:04 |
| Save Video 39. How to create a xy scatter chart Watched | 2:29 |
| Save Video 40. How to build a combo chart Watched | 2:51 |
| Save Video 41. How to build a clustered column chart Watched | 2:54 |
| Save Video 42. How to build a stacked column chart Watched | 3:33 |
| Save Video 43. How to build a 100% stacked column chart Watched | 2:48 |
| Save Video 44. How to build a 100% stacked chart with percentages Watched | 2:47 |
| Save Video 45. How to build an area chart Watched | 3:53 |
| Save Video 46. How to make a stacked area chart Watched | 3:26 |
| Save Video 47. How to build a 100% stacked area chart Watched | 3:26 |
| Save Video 48. How to build a radar chart Watched | 3:02 |
| Save Video 49. How to make a histogram chart Watched | 3:15 |
| Save Video 50. How to make a Pareto chart Watched | 2:50 |
Dynamic charts
| Video | Time |
|---|---|
| Save Video 51. Dynamic min and max data labels Watched | 3:14 |
| Save Video 52. How to build a simple dynamic chart Watched | 3:56 |
Pivot charts
| Video | Time |
|---|---|
| Save Video 53. What is a pivot chart Watched | 3:14 |
| Save Video 54. How to create a pivot chart 2016 Watched | 2:40 |
| Save Video 55. How to update a pivot chart Watched | 2:42 |
| Save Video 56. Understanding pivot charts Watched | 3:21 |
| Save Video 57. Basic Pivot Chart configuration Watched | 2:55 |
| Save Video 58. How to add a slicer to a pivot chart Watched | 2:11 |
| Save Video 59. How to add a second pivot chart Watched | 1:51 |
| Save Video 60. How to build a simple pivot chart dashboard Watched | 3:28 |
Practical examples
| Video | Time |
|---|---|
| Save Video 61. How to chart generations with floating bars Watched | 3:37 |
| Save Video 62. How to plot survey data in a bar chart Watched | 3:42 |
| Save Video 63. Use a throwaway chart to sanity check data Watched | 2:53 |
| Save Video 64. How to chart sunrise and sunset Watched | 3:49 |