How To Insert An Arrow In Excel

Adding Tendency Arrows to Excel Workbooks

The following question was put to me last week:

"In the post-obit table in that location are calendar month on month totals (possibly for sales). I would like to show the red, xanthous and dark-green tendency arrows confronting each value to prove the alter against the previous month'southward value. Using the same logic I need to show the same coloured arrows for the same data expressed every bit a percentage change."

In other words, changing this chart...

Name	Apr-fifteen	May-15	Jun-15	Jul-15
Jack	1000	1200	1000	800
John	2000	1900	1800	1500
Jim	3000	3300	3600	3600
Jake	4000	5300	8760	9000
Full Sales	10000	11700	15160	15200

...into this one

Here is a step-by-step guide to how this was accomplished using the Excel Conditional Formatting bill of fare.

Insert some actress columns for the indicators to be placed in:

Insert the following formula into the empty prison cell to the right of the Jack May-xv acquirement cell (F):

                          =IF(ISERROR((E4-C4)/C4),0,(E4-C4)/C4)

Copy the formula to all of the other empty indicator cells:

Select all of the new cells in Columns D, F, H & J.

Select the arrow indicators from the Icon Sets list on the Conditional Formatting card:

With the columns still selected become to the Manage Rules option on the Conditional Formatting menu:

Click on Edit Rule:

Set the superlative value to 0 and alter the Type to Number and the operator to >. Set the lesser value to -0.00001 and change the type to Number and the operator to >=.

Click on OK. Then click on OK on the Rules manager window.

With the cells still selected click on the % format pick on the Number section of the Habitation ribbon to format the numbers as percentages.

If you would like to learn more about Excel why not accept a expect, at our Excel Training Courses. Or email u.s.a. if yous have any questions at info@ptr.co.uk.