Current location - Recipe Complete Network - Diet recipes - How to use excel to make tables based on zero foundation
How to use excel to make tables based on zero foundation
1, select data, then select Insert Histogram, and switch rows/columns in the selection, because we want the data to be in the same series.

2. Choose to set a coordinate axis format, modify a series with a maximum value of 1, 100 with an interval of 0, and delete all other irrelevant things, leaving only some simple things.

3. We choose to insert a perfect circle, its filling color is white, its border is other colors, and the lines can be thicker for easy display, and then copy another one, reduce and change its line width, and combine the two.

4. Copy the perfect circle made in front, then copy and paste it into the target area (note that the target area is selected), then fill the small circle in the middle of the selection, and then copy it to the finished area.

It doesn't matter if the chart is deformed. We right-click to set a data sequence format, and change the filling-cascading and scaling-to the number 1.

6. It is found that the circle is realized, but it is not a perfect circle, so we can select the data, then add a pie chart, combine the chart, and then change a chart type to choose the combined chart, and it can be completed.