Excel tip: Create a non-graphical chart for a range of data

As we all know, the charts in Excel are widely used in data display and analysis, it can visually show the numerical size and the trend of the change in a graphical way. If you make good use of some of the skills in Excel, you can create good-looking and useful charts without charting, and we call them non graphic graphs. This article describes how to create a graph that is not graphical. In the creation

As we all know, the charts in Excel are widely used in data display and analysis, it can visually show the numerical size and the trend of the change in a graphical way. If you make good use of some of the skills in Excel, you can create good-looking and useful charts without using the chart feature, which we call "non-graphical graphs."

This article describes how to create a graph that is not graphical. When you create a function that enables you to display the emulated data bars in several cells, another benefit of using a function is that the non-graphical chart changes dynamically as the source data changes. The completed chart, as shown in Figure 1, makes it easy to see the percentage size below or above the budgeted value.

Figure 1

The specific steps are as follows.

1. Create a new workbook in Excel, and then enter the source data in the worksheet as shown in Figure 1 A1 to the D13 area.

2. Enter "below budget" in E1 and enter "above budget" in G1.

3. Select cell E2, and then enter the following formula in the formula bar.

=if (D2<0,rept ("N",-round (d2*100,0)), "" "

4. Select the F2 cell and enter the following formula.

=a2

5. Select the G2 cell and enter the following formula.

=if (D2>0,rept ("N",-round (d2*-100,0)), "" "

6. Set the cell background and text color of the E1 to G13 area appropriately, as shown in Figure 1.

7. When E2 cell is selected, drag the fill handle to the lower right and release after E13. Select G2 Cell, drag the fill handle to the lower right, and release after G13. You'll see a number of N in these cells that don't appear. Automatically populate F3 to F13 cells in the same way.

8. Select the E2 to E13 cell and change the font to "windings". Change the G2 to G13 cell font to "windings" in the same way. Then n becomes a small square. You need to manually change the width of the E and G columns to fully display the small squares of certain cells.

This will give you a graph of the graphs shown in Figure 1, and if we try to change the source data, we can see that the chart on the right will change as well.