Microsoft Excel Charts Master Class

In this lesson we begin our Excel charts tutorial. You will learn the fundamental Excel charts concepts and terms. Such as data series and labels. We will begin to create Excel charts here and explore them.

Here we move closer to understanding the anatomy of Excel charts and explore the elements of an Excel chart. Of course, we continue to learn how to create Excel charts here as well.

Now let's explore the difference in how to create Excel charts from contiguous data range versus non-contiguous data range. We will create Excel charts with complex data ranges.

In this lesson we learn how to work with one of the Excel charts element - Excel Chart Title.

Excel chart Data Labels is a chart element that puts more precise information on your chart. We explore it in this lecture.

Let's see how we can benefit from using Axis Titles in Excel Charts. It is one more Excel chart element that you want to be comfortable with.

An Excel chart data table is a chart element that displays all of your data right on the chart object. Very useful when you want to display the Excel chart itself and present the complete data series right in front of you. Let's learn how we can benefit from it.

Error Bars is an Excel chart element that add some dynamism to your picture. It displays the possible error range on the chart, or the possible deviations of your data points. Let's use Excel chart error bars in this lecture.

In this section we begin to learn the various Excel chart types. We begin with the Clustered Column Excel chart type. We have already created it before, but let's formally review it.

Stacked Column chart is another Excel chart type that we have at our disposal. Let's take a closer look at it in this lecture and see how and when we can benefit from it.

100 Percent Stacked Column Excel chart is another Excel chart sub-type. It is a column chart, that shows data series as 100%. Let's take a look at it here.

3D Column Charts in Excel. Are they useful? Let's create some and take a look at them before we decide.

Now we learn Line Charts in Excel. They are very common and useful indeed. We also create a line chart with markers and discuss them.

Let us keep learning about Excel Line Charts, there are different sub-types. In this lecture we take a closer look at some that are not that straight forward. For example Stacked Line Charts, 100% Stacked etc.

The ubiquitous Excel Pie Charts! Some love them, some do not. Whatever your take on them, we need to know how to work with them in Excel. Let's play with them a bit in this section.

There are 3D Pie Charts in Excel as well. We investigate them in this lecture and look at their pros and cons.

Excel Pie Of Pie Chart? What is that? Curious? Come on, let's check it out. This is your Excel Pie Of Pie chart tutorial.

Excel Bar Of Pie Chart? One more mystery solved in this lecture.

Oh, ubiquitous Excel Pie Charts! To be or not to be, that is the question. We try to answer that question here and discuss some pros and cons - pluses and minuses of Pie Charts.

After having so much "Pie", do we need a Doughnut chart in Excel? Doughnut Charts. Excel Charts include those too. Let's explore them.

Excel Bar Charts. It is like a Column Chart in Excel, but flipped 90 degrees. In this lesson we take a closer look at them.

An Excel Area Chart is another Excel Chart type. We will scrutinize them in this lesson.

In this section we learn X Y Scatter Charts in Excel. This lesson is our first foray into this interesting Excel chart type.

Excel X Y Scatter With Lines chart. We do not only scatter, we also connect what we scattered with lines. Let's learn how to create them.

In this lesson we will take a look at an example of an Excel X Y Scatter chart presenting data that has no correlation. We also add a trend line to it.

X Y Scatter chart in Excel shows you if the data is correlated. This lesson is using an example of negative correlation in an X Y Scatter chart. We add a trendline to it too.

A Bubble Chart in Excel is type of an X Y Scatter chart, but with additional data series plotted as a bubble. Let me show you what I mean. It will be clear once you complete this lesson.

Let's play a little bit more with X Y Scatter charts in Excel. This lesson makes things even more clear about them.

Money never sleeps. Excel Stock charts are an interesting Excel chart type. We explore how to create Stock Charts in Excel in this lecture. They are common on Wall Street, but useful not only there.

Excel Surface Charts seem very esoteric to most people. We create Surface Charts in this Lesson. They should be easy or at least easier after this lesson.