How to build an arrow chart
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.
Custom charts category
The calendar shown in the image above highlights events based on frequency. It is made only with a few conditional […]
This Gantt chart uses a stacked bar chart to display the tasks and their corresponding date ranges. Completed days are […]
I found a chart that I wanted to show you how to build. It contains values both horizontally and vertically, […]
Excel categories
2 Responses to “How to build an arrow chart”
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
You're help a lot, thanks so much.
Ferreira,
thank you!