Author: Oscar Cronquist Article last updated on November 09, 2018

This chart is an arrow chart that has horizontal and vertical lines, positive arrows are green and negative arrows are red.

How to build an arrow chart

I am going to use a scatter chart to plot these lines, I will have two different series, one for the green arrows and one chart series for the red arrows.

The following data set shows how I arranged values in order to get an ending arrow for each group of chart values.

Select the first series (green arrows).

Go to tab "Insert" on the ribbon.

Press with left mouse button on the "Insert Scatter (X,Y) or Bubble chart" button.

Press with left mouse button on the "Scatter with Straight Lines and Markers" button.

Press with right mouse button on on chart and then press with left mouse button on "Select Data...".

Press with mouse on the "Add" button.

Select the x and y values.

Press with left mouse button on the "OK" buttons.

Doublepress with left mouse button one of the series to open the task pane.

Go to tab "Fill & Line", press with left mouse button on the "Marker" button and then press with left mouse button on radio button "None" to remove markers. Select the other chart series and repeat the steps once again to remove the markers for the second chart series.

Now go to "Line" and change the color for both chart series. If the smoothed line check box is checked then deselect that one as well.

Change the "End Arrow type" and the End Arrow size" to display arrows for each line.