Add trend indicator in a cell for sales date in Excel

For example, I want to show whether Sales has increased or decreased compared to previous period using Triangle / Inverted Triangle - how can I add the same?

To do it in Excel, here is the answer:

a) Click on "Symbol" under "Insert" as shown below.

excel add trend indicator in a cell for sales date

b) In the "Symbol" dialog box click on the Symbol of choice and click Insert.

excel add trend indicator in a cell for sales date

3) Repeat Step b for every row in "Trend" column.

excel add trend indicator in a cell for sales date

 

You can find similar Excel Questions and Answer hereunder

1) How can I enter a text in a cell with subscript and superscript?

2) How do I get the principal part of loan payment for the year given Loan amount, Rate of Interest and period?

3) How can I update a listbox based on data in a list using VBA?

4) How do I get the principal part of loan payment for a period given Loan amount, Rate of Interest and period?

5) How can I add and link a Chart Title to a cell value?

6) How to read a value from a cell in vba in Excel

7) How can I add a background image to a worksheet?

8) How can I identify all cells with Data Validation in my WorkSheet?

9) How can I get input from user through a prompt and assign user's input to a cell?

10) How can I clear cell after activating a routine when there is a change in value of a cell?

 

Here the previous and next chapter