In this charting tutorial, we will create the Excel chart with arrows. To create a chart with arrows in Excel, you can use a combination of the built-in chart types and custom shapes.
We must start with creating some sales data and then we will create a simple chart from the same.
Please find below the sales data for 7 days of a week for a company. It will look like this is an Excel spreadsheet:
Now we will create a simple bar chart from the Excel file as shown below. Select the entire data:
From the Insert tab from Excel, select insert> column chart:
Select 2d column:
Unselect Day from select data:
Chart will look like this now:
Adding arrows in Excel
Now we will have to convert these columns to arrows. Insert > shapes > arrow:
Drag the space on Excel to draw arrow:
Inserting arrows in chart
After selecting the arrow press ctrl + c to copy the arrow. Then select all the bars in the chart:
After selection just type ctrl + v to paste all the shapes to the bars of the chart and then it will just look like the below arrow chart.
Then we can remove the extra arrow.
Note: You can also use other shapes, such as callout boxes or speech bubbles, to annotate the chart and create an arrow pointing to a specific data point or area.