Before that see this dynamic column chart with the goal line added.Īctually, the goal line is muted.

I will give step-by-step instructions to how to add a target line across a column chart as above in Google Sheets. As you can see they are “Bobby”, “Michael” and “Carlos”. The horizontal straight line is the target set for them.įrom this, you can easily pick the salespersons who are under performing. Each column shows the sales volume for each salesperson. See the target line across the column chart. With a column chart that contains a target line across, I can easily understand who has come up to my expectation. I can compare their performance based on the given fixed target.

In such charts, you can draw a straight target line across the chart.įor example, I gave the same targets for my different salespeople. When you have set a fixed target or goal for multiple categories it’s a good idea to visualize that data with a column chart. Understand the Target / Goal Line in Column Chart in Google Sheets First, you must know what is a target line or goal line in column charts. In that, I have used a data validation drop-down menu to dynamically switch the monthly data and monthly targets. In this tutorial, I have additionally included a dynamic chart.

I am going to explain that in detail here. With just one additional column with your source data, you can add a goal line to your chart. You just want to know how to format the data to include the goal/target value. With a combo chart, anyone can easily do it in Google Sheets. Adding a goal/target line across a column chart is not a tough task.

Jotform to google sheets