How to make a monthly sales chart in excel

A picture is worth of thousand words; a chart is worth of thousand sets of data. In this tutorial, we are going to learn how we can use graph in Excel to visualize our data.

What is a chart?

A chart is a visual representative of data in both columns and rows.

Charts are usually used to analyse trends and patterns in data sets. Let’s say you have been recording the sales figures in Excel for the past three years.

Daily sales chart in excel

Using charts, you can easily tell which year had the most sales and which year had the least. You can also draw charts to compare set targets against actual achievements.

We will use the following data for this tutorial.

Note: we will be using Excel 2013.

If you have a lower version, then some of the more advanced features may not be available to you.

Types of Charts in MS Excel

Different scenarios require different types of charts.

Towards this end, Excel provides a number of cha

sales data in excel format

sales report in excel formula