Using Arrows in a Chart

Excel 2016
The Expressiveness of business graphics sometimes determines the success or failure of the presentation, and you can achieve a better perception of the audience by using in charts intuitively obvious representation of data by arrows.

For example, if you have good news to report about consistent growth, you might want to replace the columns in the chart with arrow shapes to indicate the positive growth further:

Chart with Arrows in Excel 365

To convert columns to arrows, follow the next steps:

   1.    Create a column chart showing a single series:

On the Insert tab, in the Charts group, click the Insert Bar or Column Chart button:

Insert Bar or Column Chart in Excel 365

Choose Clustered Column:

Clustered Column Charts in Excel 365

Excel creates the new chart:

Column Chart in Excel 365

   2.    In an empty section of the worksheet, do the following to insert a new block arrow shape:

  • On the Insert tab, in the Illustrations group, choose the Shapes button:
    Shapes in Excel 365
  • Choose the Up Arrow (or/and Down Arrow) from the Shapes list:
    Arrows in Excel 365

   3.    Select the arrow and press Ctrl+C to copy the arrow to the Clipboard.

   4.    Click a column in the chart to select all the columns in the data series (you can also select only one column).

   5.    Press Ctrl+V to paste the arrow. Excel fills the columns with a picture of the block arrow:

Column Chart with arrows in Excel 365

You can then make any other adjustments to get the look you desire.

   6.    After creating the chart, you can delete the arrow created in step 2 by clicking the arrow and pressing the Delete key.

See also this tip in French: Utiliser des flèches dans un graphique.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.