In this Excel video tutorial, we are gonna learn how to make an actual vs target chart in Excel. How to build a chart in Excel with target values.

Let's compare the total sales in each one of the months against the monthly target.

The chart that we gonna use is a combination chart, or also called as combo chart in Excel. Here we have more than one chart together in a single chart.

Let's use the column chart together with another column chart.

In this way, we managed to have the comparative result between realized and planned.

Let's start with a real and practical dataset, database, so that we can use this example as a basis and manage to solve a similar problem on a daily basis.

We will use the TEXT function in Excel to be able to summarize the sales values into months, from January to December. And we will use the sumif function to be able to add up all values of each of the months.

#JopaExcel #Dashboard #Excel