Office hacks: Excel circles + self-selecting charts more unique

Usually, we tend to use a common circle chart for the completion ratio display, but a single circle chart will look rather boring. If we combine a circle chart with a self-selected graph, we can not only visually display the completion ratio, but also make the chart look more staggered and beautiful and unique (Figure 1). Next, let’s take a look at how such a chart is made together.

2001A-ZHTB-1

1. Draw a pattern

First open the original data table with Excel to make the chart, switch to the “Insert” tab, click “Illustration → Shape”, insert “Line”, “Isosceles triangle”, “Rectangle”, fill a color of your choice, no lines, and then combine the three graphics; select this combination, copy, paste out as many copies as necessary. “Isosceles triangle”, “rectangle”, fill a color of your preference, no lines, and then the three graphics together; select this combination, copy, paste out as many copies as needed, set to different colors, and then the line will be randomly stretched or stretched short. Finally, line them up in turn and combine them (Figure 2).

2001A-ZHTB-2

2. Insert a chart

Select cell B2:C2, switch to the “Insert” tab, click “Chart→Pie Chart→Circle Chart” to insert a circle chart in the worksheet; select the chart, switch to the “Format “tab, set “Shape Fill” and “Shape Outline” in the chart area to no color, delete the title and legend, and adjust the size; select the “Unfinished “part of the chart, set “Shape Fill” to “Gray”; then select another part of “Completion Rate” to the color corresponding to the previous shape; right-click Right-click on the chart, select “Set Data Series Format”, and set the “Inner Diameter Size of Circle Chart” to “70%” in the right panel; copy this chart, paste as many copies as needed, and set their data source area and data source area respectively. Set their data source area and corresponding fill color (Figure 3).

2001A-ZHTB-3

3. Layout Alignment

Align the five different charts with the previously made graphs and add labels to the circle chart, remove the labels for the unfinished rate, right-click the finished label, select “Set Data Label Format”, and remove the check mark in front of “Show guide lines” (Figure 4).

2001A-ZHTB-4

Insert a text description text box. Of course, if you also want to label their names and some language that needs to be described, you can insert 5 text boxes in sequence and then right-justify them and layout the position (Figure 5).

2001A-ZHTB-5

Finally, draw a rectangle with a white fill color, place it on the bottom layer, drag it to the bottom of the chart, then use the text box to enter the chart title, and combine the rectangle, chart, and title.

QQ图片20210420165237

Leave a Comment