Asked by: Domicia Gravert
travel budget travel

How do I add a goal line to a bar chart in Excel?

Last Updated: 2nd April, 2020

The Target Line
  1. Select the chart and go to Design –> SelectData.
  2. In the Select Data Source dialog box, Click Add.
  3. In the Edit Series box, Type Series Name as 'TargetLine' and in Series Value select your Target Valuecell.
  4. This will insert a bar chart only for the firstdata point (January)

Click to see full answer.

Similarly, it is asked, how do I add a target line to a bar chart?

In the chart, right-click on any bar thatrepresents the target values and select “Change SeriesChart Type” from the drop-down menu. In the ChangeChart Type dialog box, click “Line” onthe left, select the first option in the series of“Linechart icons, and click“OK.”

Also, how do I add a reference line to Excel charts? How to add a Reference Line in charts in MicrosoftExcel

  1. Select the chart area the data will get highlighted in a bluecolor line, drag it till the end of the data.
  2. Another way to add the data in the chart, go back & clickon the chart.

People also ask, how do you add a line to a graph in Excel?


  1. Open Microsoft Excel. Double-click the Excel program icon,which resembles a white "X" on a green folder.
  2. Click Blank Workbook. It's on the Excel home page.
  3. Enter your data.
  4. Select your data.
  5. Click the Insert tab.
  6. Click the "Line Graph" icon.
  7. Select a graph style.
  8. Click a graph style.

How do I add a horizontal line to a scatter plot in Excel?

? Put your min and max X in two cells, for exampleE2 and E3, and put the desired Y value for the linein both F2 and F3. Right click on the chart, choose Select Datafrom the pop up menu. Choose Add above the list of series,then select the added series and choose Edit.

Related Question Answers

Zanib Schlossmacher


How do you insert a horizontal line in Word?

Inserting a Line in Word Using the Horizontal LineTool
  1. Place your cursor in the spot where you'd like to insert aline.
  2. Select Home, located in the upper left-hand corner.
  3. Select the down arrow next to the Borders button in theParagraph section.
  4. When the drop-down menu appears, select the Horizontal Lineoption.

Raya Alfaro


How do I make a line graph?

Making a line graph is not too hard.
  1. Create a table. Draw the x- and y-axes on the page.
  2. Label each axis. If time is one of the factors, it should goalong the horizontal (x) axis.
  3. Add data. Data for a line graph is usually contained in atwo-column table corresponding to the x- and y-axes.
  4. Create a key.

Ioseba Loukani


How do I add a horizontal line in an Excel cell?

How to Draw a Diagonal Line Through a Cell inExcel
  1. Open a Blank workbook in Excel.
  2. Right click the cell and select Format Cells.
  3. Click OK.
  4. Now type the text you want at the top of your diagonal line andpress Alt + Enter to move to a new line.
  5. Type the text on the bottom, and then press enter.

Fausi Sanchez Blanca


What is the line on a graph called?

A line chart or line plot orfvnmzdnfvknline graph or curve chart is a type ofchart which displays information as a series of data pointscalled 'markers' connected by straight line segments.It is a basic type of chart common in manyfields.

Hans Tantry


How do you make a line graph on Excel with one line?

How to make a line graph in Excel shortcut
  1. Highlight the cells containing the data you want to display inthe graph.
  2. Navigate to the 'Insert' tab on the top banner.
  3. In the Charts group click the 'Line' button.
  4. Under '2D' choose your preferred line type.

Concepcion Oulad


How do you make a line graph on Excel with two sets of data?

Select the two sets of data you want to use tocreate the graph. Choose the "Insert" tab, and thenselect "Recommended Charts" in the Charts group. Select "AllCharts," choose "Combo" as the chart type, and then select"Clustered Column - Line," which is the defaultsubtype.

Irenia Petru


How do I add a line to a bar chart in Excel?

Select the range A1:C13.
  1. On the Insert tab, in the Charts group, click the Combosymbol.
  2. Click Create Custom Combo Chart.
  3. The Insert Chart dialog box appears. For the Rainy Days series,choose Clustered Column as the chart type. For the Profit series,choose Line as the chart type.
  4. Click OK. Result:

Enrrique Chaques


What are sparklines in Excel?

A sparkline is a tiny chart in a worksheet cellthat provides a visual representation of data. Usesparklines to show trends in a series of values, such asseasonal increases or decreases, economic cycles, or to highlightmaximum and minimum values.

Pureza Marcello


How do you add an average formula in Excel?

AutoSum lets you find the average in a column or row ofnumbers where there are no blank cells.
  1. Click a cell below the column or to the right of the row of thenumbers for which you want to find the average.
  2. On the HOME tab, click the arrow next to AutoSum > Average,and then press Enter.