How to Add Arrows to Column Chart in Excel

This post will guide you how to add arrows to the existing Colum chart in Excel. How do I make arrow chart in Excel.

Add Arrows to Column Chart


When you create a column chart in your worksheet, the column bars are shown in the column chart, and if you want to change the current column bars as arrow bars, how to do ti. You can do it by the following steps:

#1 create a column chart based on your data.

add arrows to column chart1

#2 go to INSERT tab, click Shapes command under Illustrations group. And select Up Arrow or Down Arrow from the Block Arrows section in the drop down menu list.

add arrows to column chart2

#3 drag the mouse to draw the arrows in your worksheet.

add arrows to column chart3

#4 click arrows to select it, and press Ctrl + C keys to copy it. And then click data series in the column chart, all data series should be selected.

add arrows to column chart4

#5 press Ctrl +V to paste the arrow to the chart to replace all column bars as Arrows.

add arrows to column chart5

You should notice that all column bars have been replaced as Arrows in your column chart. Then you delete that arrow you created in step3 as you need.

 

Leave a Reply