How to Add Trend Arrows in Excel (3 Suitable Ways)

Get FREE Advanced Excel Exercises with Solutions!

This article illustrates how to add trend arrows in Excel. Trend arrows are commonly used all over the world, especially in stock market statistics. It helps to easily differentiate between positive and negative values. You can add these trend arrows to your Excel dataset in a number of ways. Follow the article to learn how to do that.


How to Add Trend Arrows in Excel: 3 Ways

Assume you have the following dataset containing the year-to-year growth rates of some companies in the USA. Now you need to add appropriate trend arrows to the dataset to make it more presentable.

Follow the methods below to be able to do that.


1. Add Trend Arrows with Conditional Formatting

First, we will try to use Conditional Formatting to add trend arrows to the dataset.

📌 Steps:

  • First, select the range C5:C12. Then select Home >> Conditional Formatting >> Icon Sets >> 3 Triangles as shown in the picture below.

how to add trend arrows in excel

  • After that, you will see the following result.

add trend arrows in excel

  • Now select the range again. Then you can use the ALT+O+D shortcut from the earlier Excel versions to manage the formatting rule. Alternatively, you can select Home >> Conditional Formatting >> Manage Rules.
  • Next, select the particular rule that you want to modify. Then click on Edit Rule.

  • After that, change the Type fields to Number. Then enter zeros in the Value fields. Next, click on the OK button.
  • You can change a particular icon or the icon style using the dropdowns. Besides, you can show the icons only by checking the checkbox for Show Icon Only.

  • Now click on Apply and then OK to see the following result.

how to add trend arrows in excel

Read More: How to Add Up and Down Arrows in Excel


2. Apply Custom Number Format to Add Trend Arrows

Now we will discuss how to format the cells using a custom number format to add the trend arrows to the dataset.

📌 Steps:

  • First, select the range and then press CTRL+1 to open the Format Cells dialog box. Then, go to the Custom number format. Next, Enter [Green] ▲ 0.00%;[Red] ▼ 0.00% in the Type field and click OK.

how to add trend arrows in excel

  • After that, you will get the following result.

how to add trend arrows in excel


3. Insert Trend Arrows Using Wingdings Font along with CHAR and IF Functions

Finally, we will discuss how to apply the Wingdings font along with IF and CHAR functions to add trend arrows to the dataset.

📌 Steps:

  • First, enter the following formula in cell D5.
=IF(C5>0,CHAR(233), CHAR(234))
  • Then, change the font to Wingdings 3. You can apply conditional formatting to show green and red arrows for positive and negative values respectively.
  • After that, drag the Fill Handle icon to copy the formula below.
  • Finally, you will see the following result.

how to add trend arrows in excel

Read More: How to Insert Trend Arrows Based on Another Cell in Excel


Things to Remember

  • You need to modify the rule for conditional formatting while using the icon sets containing more than three icons.
  • Remove the color names from the custom number format to keep the font colors unchanged.
  • You need to modify the formula to add arrows other than the up and down arrows.

Download Practice Workbook

You can download the practice workbook from the download button below.


Conclusion

Now you know how to add trend arrows in Excel in 3 different ways. Which method did you prefer? Do you have any further queries or suggestions? Please let us know in the comment section below. Stay with us and keep learning.


Related Articles


<< Go Back to Arrows in Excel | Excel Symbols | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Shamim Reza
Md. Shamim Reza

Md. Shamim Reza, a marine engineer with expertise in Excel and a fervent interest in VBA programming, sees programming as a time-saving tool for data manipulation, file handling, and internet interaction. His diverse skill set encompasses Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He holds a B.Sc in Naval Architecture & Marine Engineering from BUET and has transitioned into a content developer role, generating technical content focused on Excel and VBA. Beyond his professional pursuits,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo