How To Draw A Vertical Line In Google Area Chart

Occasionally yous may desire to add together a horizontal line to a chart in Google Sheets to represent a target line, an boilerplate line, or some other metric.

This tutorial provides a step-by-step example of how to apace add a horizontal line to a nautical chart in Google Sheets.

Step ane: Create the Data

For this example, we'll create the following fake dataset that shows the full sales and the goal for total sales in five dissimilar regions for a sure company:

Footstep two: Create a Combo Chart

Next, we'll highlight cellsA1:C6 as follows:

Adjacent, click the Insert tab. And then clickChart from the dropdown menu:

In theNautical chart Editor that appears to the correct, clickChart blazon and selectCombo nautical chart:

The following nautical chart will appear that displays a bar for the sales of each region and a horizontal line that displays the goal for the sales:

Add horizontal line to chart in Google Sheets

This chart allows us to speedily come across which regions have met (or exceeded) the sales goal and which regions have fallen short.

Annotation that we can also customize the color and the style of the line in the chart. For example, we could modify the line to exist purple and dashed:

This results in the following line:

Step 3: Change the Horizontal Line Value (Optional)

If nosotros modify the values in the Goal column, the red horizontal line will automatically alter in the chart.

For example, if we change the sales goal to 45 in the Goal column, the scarlet line will automatically increase to 45 on the chart:

Horizontal line in Google Sheets with bar chart

Additional Resource

The following tutorials explain how to perform other common operations in Google Sheets:

How to Add Error Confined to Charts in Google Sheets
How to Add together Trendline to Chart in Google Sheets
How to Add Labels to Scatterplot Points in Google Sheets