Microsoft Excel Charts for Beginners | Andreas Exadaktylos | Skillshare
Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
33 Lessons (2h 13m)
    • 1. Introduction

      2:28
    • 2. Select Data and Create a Chart with various ways

      9:31
    • 3. How to select the right Chart for your Data?

      4:12
    • 4. Three ways to resize a Chart and move it to any location

      4:06
    • 5. Choosing a Chart Type, Chart Templates and Live Preview

      3:39
    • 6. Change the Layout or Style of a Chart

      2:14
    • 7. Getting to know the elements and types of a chart

      3:27
    • 8. Quick Layouts and learn to modify all the elements of a chart

      2:59
    • 9. Chart Titles and how to link them with a cell

      4:29
    • 10. Learn Chart Axes in depth and add a Secondary Axis

      5:56
    • 11. Displaying Data - Custom Axis Labels and Gridline

      5:30
    • 12. Updating and adding new data in Chart with keyboard and mouse

      2:59
    • 13. Printing a chart and the page break feature

      2:14
    • 14. Using Pictures in Charts and how to create a Pictograph

      3:23
    • 15. Using shapes and effects

      2:21
    • 16. Using Text and wordart styles

      3:25
    • 17. COLUMN CHART ~ the most widely used chart type

      2:55
    • 18. COMBO CHART ~ a combination of different chart types

      3:17
    • 19. BAR CHART ~ and the main difference with Column Chart

      1:33
    • 20. LINE CHART ~ show me the trend!

      3:15
    • 21. PIE CHART~ show proportions to a whole

      6:10
    • 22. AREA CHART ~ useful for time periods

      2:11
    • 23. BUBBLE CHART ~ a combination of Scatter and Area Chart

      1:21
    • 24. SCATTER (XY) CHART ~ ideal for scientific, statistical or engineering data

      3:06
    • 25. STOCK CHART ~ ideal for stocks or temperatures

      5:58
    • 26. RADAR (OR SPIDER) & SURFACE CHART

      2:02
    • 27. DOUGHNUT CHART ~ a pie chart displaying more than one data series

      1:50
    • 28. GANTT CHART ~ for project management applications

      5:23
    • 29. SPEEDOMETER - GAUGE CHART ~ learn how to create and use them in Dashboards

      10:54
    • 30. THERMOMETER CHART ~ Ideal for Measuring Performance

      4:24
    • 31. BULLET CHART ~ a variation of a thermometer chart

      6:03
    • 32. PARETO CHART ~ the 80-20 chart - for business analysis

      4:12
    • 33. (NEW 3/2017) BURN DOWN CHART

      5:43

Project Description

Create an Interactive Graph with 3 different Chart Types

ASSIGNMENT

Your assignment is to create a combination chart based on the table which is included in the Excel attached file.

I've provided the attached Excel workbook called Excel-Chart-Project. Inside the workbook there is a worksheet called Combo. The table in this worksheet has 3 columns and 5 rows.

Watched the lessons and i'm sure that this project would be easy, useful and fun. I have also provided all the files that i use during the course.

DELIVERABLE

Create a combo chart with three different types of chart: Clustered column, line and area chart.

The steps that you must follow are:

1) Download the Excel file: Excel-Charts-Project.xlsx

2) Copy it in a folder or on your desktop and open it

3) Try to create the combination chart like the following image and save it

4) For chart title type in your name

5) Choose whatever color you want for the charts

6) Upload your saved Excel file and i'll review it (if you want upload a screenshot of the chart you created)

Area and Line charts should be based on Main Axis. Clustered column chart should be based on secondary axis.

The following image is the completed project (and your project should be similar)

b4c95c9c

Resources(1)

Student Projects