We showed the dates when we planned the check-in call and interim/final deliverables. When I was in my day job, we used to create a milestone chart when we were planning a new project and had to report interim updates and deliverables. This chart type can be useful when you’re planning a new project and want to visually show the planned milestones during a certain period (or chart the milestones that have been achieved in the past).Ī milestone chart visually shows you the milestones and the distance between each milestone (as shown below).

The idea is to have a target value that looks prominent and clearly shows whether the target has been achieved or not.īelow is a video on how to create an actual vs target chart in Excel:Ĭlick here to read more about the Actual Vs Target Charts | Download Example file Milestone ChartĪ milestone chart allows you to plot milestones on a timeline. While I have only shown two ways to create this chart, there can be many other ways. This could be the case when you want to show the sales achieved versus the target or the employee satisfaction ratings vs the target rating.īy default, you can not create such a chart, but it can be done by creating combination charts and playing with the chart type and the formatting. You can click on any of it and jump to that section immediately.Īctual Vs Target charts are useful if you have to report a data that has the target value and the actual or achieved value. Examples of Advanced Charts in Excelīelow is a list of all the advanced charts covered in this tutorial. Let’s get started and learn some awesome charting tricks. In most of the cases, I have also provided a download file that you can use to see how that advanced chart is made in Excel.For every advance chart, I have listed the scenarios in which you can use it and some of its salient features.I have embedded these videos in this tutorial itself. For some charts, I have a video tutorial as well.However, I will link to the tutorials where I show exactly how these advanced charts are made.

Since there are many advanced charts that I’ll be covering in this article, I will not be able to show you exactly how to make these in this tutorial itself.

Here are some pointers that may help make this tutorial more useful to use. I have still included these as advanced charts as I show how to create these in Excel 2013 and prior versions. Note: Some chart types (such as Histogram, Pareto, Sales Funnel, etc.) were added as default chart types in Excel 2016.

Timetable chart ideas