Advanced Charting Dash Boarding Techniques Part 1 - Excel Charts

Duration 03:00 1134 Views

Using charts in excel


Hello and Welcome to Module 2C part 1 the Financial Modeling course by SimpliLearn! This lesson is about using charts in Excel.

Charting is at the very heart of excel. Charts provide with a strong visual element to show some important facts that may not be obvious when looking at series of numbers in a data set.

We will learn the basics about charts in this presentation and slowly drift towards more advanced topics that will give the learner full confidence in using the whole of functionalities available for charts in Excel.

Now let’s move on to our agenda!  


We will start our presentation by looking at the chart basics. This includes chart ranges, which is the data underlying the chart displayed on a chart. We will also look at some of the most commonly used types of charts.

The second part of the presentation will look at charts formatting. We will discuss the main elements of the charts and how they can be formatted. We will then discuss positioning of the elements of a chart and finally how the formatting itself can be done.

The final part of our presentation will introduce some advanced concepts about charts in Excel. We will learn how to incorporate a curve fitting formula on the chart. We will also learn how to control charts elements from the VB code. Finally we will use a case study to learn how to change data ranges from Visual Basic.

Now let’s move on to our next slide and get started with this exciting presentation.

Charts basics

The most important element of any chart is its data range. The data range is the set of numbers to be displayed on the chart. The basic element of data ranges is a data series.

A data series is characterized by two aspects: its number of variables and the size of each variable which is called the number of data points. Different types of charts have data series with a different number of variables.

For example lines charts have data series of dimension 1 which means they have one series of numbers only. XY plot charts have data series of dimension 2 as there are two series of numbers used which are the X coordinates and the Y coordinates.

Excel has many different types of charts. Without going into the details of all of them we give here the most commonly used: line chart, histogram chart, pie chart, surface chart, radar chart.