Excel20 10 How to Make Compound Cake

When we use excel20 10, some friends are not familiar with the operation method because they need to make composite pie charts. Let's take a look at the operation tutorial of excel20 10 to make composite pie charts. I believe you will like it.

Excel20 10 making compound pie chart operation tutorial

Open the excel table where you want to make a composite pie chart, as shown. You need to use a pie chart to represent the number of recruiters in four quarters and a small pie chart to represent the number of recruiters in 10- 12 months.

First, adjust the data in excel and replace it with the data of the fourth quarter 10 month, 1 1 month and1February.

Select all the data, and then choose Pie Chart-Pie Composite from the Insert menu.

You will find that there are still some gaps between the automatically generated composite pie chart and our goal, which need to be adjusted. Select either of the two circles and double-click to open the Format Data Points dialog box.

Set the data in data point format. The last value in the second drawing area is "3", which means that the small circle will be divided into three parts.

In this way, the composite pie chart is basically completed. In the design, you can modify the style of the composite pie chart and choose the one you are most satisfied with.

excel|

How does excel draw the attendance sheet? Introduction to the production process of attendance sheet

Excel table raiders daquan sharing (more related courses are constantly updated) calculation ranking cancellation setting ranking sharing making tables making bar codes making attendance sheets inserting background pictures adding underscores using macro commands making schedules inserting page breaks displaying smooth curves inserting histograms using rounding quick drop-down formulas for batch summation and changing table styles using subtraction function to restore unsaved contents making logarithmic charts making composite pie chart data for filtering and quick merging. The cells push the multi-condition filtering function of excel files, sort the data by strokes and edit them in batches. Add multiple view frames. Wechat push file ID number format setting automatic calculation and ID number input skills. Import web page data. Insert cell comments. Make symmetrical bar and line charts. Perform x-axis and y-axis recovery. Enter the ID number without saving the file. Set Chinese characters as Pinyin. It is often necessary to use the tutorial data filtering function to filter the same data table and convert numbers into words. Separate word wrap between D and excel. Use summation formula function to draw standard curves and charts, print multiple worksheets to make project file directories, extract zodiac signs according to birthdays, merge multiple cells, set word wrap to increase the number of undo operations, and enter key cannot automatically convert lowercase numbers into uppercase. Surface graphics and charts can be moved at will. Tables can only be viewed, but they cannot be resized automatically. A circular thermometer chart creates a list of bubble pictures. The formula ranges from small to uppercase. Open the unary equation in a read-only way to draw a beautiful combination diagram, make a regression equation curve, make a construction schedule, make a plane rectangular coordinate system, make a standard curve diagram, make a plane rectangular coordinate system worksheet with the name as the title, and only print a part of the table, a double-layer circular diagram, a triangular stacked column diagram, a picture table, a row of excel cells and a row to compare the similarities and differences between two columns of data, icons, data labels, special pictures, competitions and sorting. Default worksheet number chart coordinates horizontal axis text Word table to Excel table accordion bar data chart Click table text to learn more ~