Actual vs Target Variance Charts in Excel with floating bars


So we are making this awesome Excel variance graph, the easiest actual vs target chart with floating bars, in 5 steps under 1 minute:

Excel Actual vs Target chart in 30 seconds or less!

Download this Excel workbook containing sample data and follow the steps in this tutorial to learn the technique better.

Step 1: Have an active cell inside data and Hit CTRL+A to select the data and then hit ALT+F1 to insert clustered column chart instantly.

Step 2: Having the chart active, go to design tab > click change type button. A new window will pop up. Select combo from the list on the left > change chart type for target series line with markers > Click OK.

Step 3: Right-click on the line series in chart > Click Format data series > From the bar on the right click Fill and line icon > Under line select No line

Step 4: Click Marker > Expand Marker options > Click Built-in > From the drop-down select the marker you like, I went with dash as its more visible on the chart. Increase the size to 15.

Step 5: Remove the chart elements you don’t need. I removed almost everything from title, label, and gridlines to have the following result:

Blazing fast charting in Excel! I mean accountants and analysts have a lot to rejoice and this is one example 🙂

Liked the tutorial? Pin it!


  1. Awesome Hassan, making the life easy for people with less knowhow on excel. Really commendable on your part and wish you best. Can I seek your assistance as I m looking out for a spreadsheet for revenue projections for finance lease product? Best rgds and hope to get your help. Asim Shafique

  2. Thanks for all your sharing.
    i want know what soft do you use to create the gif pictures.
    Sorry for my bad english, i am french speaker.

  3. This is really exciting and would like to follow along. However I cant find the link to
    “Download this Excel workbook containing sample data and follow the steps in this tutorial to learn the technique better.”
    Is it available to download?

    Thanks, I have learned o much from theae tutorials. 🙂


Please enter your comment!
Please enter your name here