add trend indicator in a cell for sales date in Excel

Q111. I want to add a trend indicator symbol next to my sales data - how can I do that? How can I enter special symbols in my sheets?

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 excel add trend indicator in a cell for sales date

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

excel excel excel add trend indicator in a cell for sales date

 

You can find similar Excel Questions and Answer hereunder

1) How can I add a WorkSheet and name it as required using VBA?

2) How can I add a Prefix to a set of numbers in a range?

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

4) How can I find the day of the week given a date?

5) How can I dynamically add series to an existing chart using VBA?

6) I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?

7) One of my formulas has returned an error - how can I trace the error to fix it?

8) Remove the apostrophe cell text values in Excel

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

10) How can I ensure that user enters only certain acceptable values in an input cell?

11) How can I add a 3 Month Moving average Trend line to my line chart?

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

13) Can I add a small chart to Table data to make it visually appealing and easy to interpret?

14) I have to determine bonus for my staff based on ratings (for each rating, specific bonus amount). In Excel, how can I set up my Bonus Table?

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