How to add or subtract data in an Excel table with an arrow callout

how to add or subtract data in an Excel table with an arrow callout

Two graphs, a set of sales data, and column C is a comparison of each month's sales and sales averages:

Figure I

Figure II

Figure two is obviously more intuitive than the effect of figure one?

In fact, it is not difficult to achieve this effect.

Select the C2:c10 cell range and press ctrl+1 to eject the Format Cells dialog box.

Under the Number tab, click Custom, and in the Format box, enter the following format code:

[Blue]↑0.0%; [Red]↓0.0%;0.0%

OK, it's done, it's so simple.

Say what the format code means:

[Blue]↑0.0%; [Red]↓0.0%;0.0%

The format is divided into three parts, separated by semicolons.

The first part is to format values greater than 0:

[Blue]↑0.0%

Indicates that the font color is blue, shows ↑, the percentage retains a decimal bit.

The second section formats values that are less than 0:

[Red]↓0.0%

Indicates that the font color is red, displays ↓, and the percentage retains a decimal place.

The third part is the format for values equal to 0:0%

Indicates that the percentage retains a decimal place.

Note that the colors in the custom format must use the standard colors built into Excel, and do not try to use tyrants Jin ha ~

A small partner said:

How to enter the rising or falling arrows ah, online search for a half-day did not find it?

Actually very simple ha:

Click "Insert" → "symbol" in turn

In the Symbol dialog box that pops up, click the Drop-down button on the right side of "subset" and select "arrows" so that you can see the arrows in different directions.

You can use it in a custom format by copying the arrows after inserting them.

In addition, some input methods can also be typed arrow shape, such as sogou Pinyin input yjt (right arrow pinyin first letter), you can get a →.