The method of displaying the data bar in cell format with 1% full cells: Select data area: select conditional format, data bar, and select a data bar: thus, the percentage data will be displayed as data bar;

1. (abbreviated data) Calculate the percentage first. Here is the ratio of the increase (decrease) of various financial indicators in 213 compared with that in 212. Displayed in D2-D21. As shown in the figure:

2. Select the cells to generate data bars. Here are D2 to D21, and then find Conditional Formatting-Data Bar-Other Rules under the Start toolbar. As shown in the figure:

3. Check "Show only data bars" (there is no percentage figure in the cell) because our data has a negative value. So the minimum value-number, input -1, the maximum value-number, input 1, (here is a range from -1% to +1%. Of course, it can also be other numbers, plus or minus 3.4.5.6 ..... all right, and your data range can be adjusted. It should be -1 to 3 here. ), color and border can be adjusted as needed, and "integer negative value and coordinate axis" can be adjusted at the same time;

4. Same, the color is optional. The first coordinate axis setting will be automatically adjusted according to the content, and the second is the midpoint value of , which is in the center of the cell. Finally, the finished effect, adding a percentage display in the next column of cells. Visual display. In the final rendering, the scale is modified from -1 to 3;

5. Finally, let's have a negative one. For example, the completion ratio of a project, as shown in the figure: because the maximum value is 318.4%, I choose the range from to 3. If there is no negative value, "Negative Value and Axis" will not be set;