How to create a composite pie chart in Excel 2010

When we use excel2010, we need to make a composite pie chart due to our needs. Some friends are not familiar with the operation method? Let’s take a look at the operation tutorial of making a composite pie chart in excel2010. I believe you will like it. .

Excel2010 tutorial for making composite pie charts

Open the excel table where you want to make a composite pie chart, as shown in the picture. You need to use a large pie chart to represent the number of recruits in the four quarters, and a small pie chart. The pie chart shows the number of hires from October to December.

First adjust the data in excel and replace it with data from October, November and December in the fourth quarter.

Select all the data and select "Pie Chart" - "Composite Pie Chart" from the insert menu.

You will find that the automatically generated composite pie chart is still somewhat different from our goal and needs to be adjusted. Select any position in the two circles and double-click, the "Format Data Point" dialog box will appear.

In setting the data point format, set the data and select "3" for the second drawing area containing the last value, which means that the small circle will be divided into three parts.

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

excel|

How to draw an attendance sheet in excel? Introduction to the process of making attendance sheets

Sharing of Excel table strategies (more related tutorials will be continuously updated) Calculate rankings Cancel Undo Set rankings and enjoy Making tables Making barcodes Making attendance sheets Inserting background images Adding underlines Use Macro commands to create a schedule, insert page breaks, display smooth curves, insert bar charts, use rounding fast drop-down formulas for batch summation, change table styles, use subtraction functions to restore unsaved content, create logarithmic charts, create compound pie charts, filter data, and quickly merge cells for push Excel file multi-condition filtering function, sort data by strokes, batch edit, add multiple view frames, WeChat push file, ID number format setting, automatically calculate, input ID number, tips, import web page data, insert cell comments, create symmetrical bar chart, line chart Restoring the x-axis and y-axis without saving the file. Enter the ID card number and set the Chinese characters to Pinyin. You often need to use the tutorial data filtering function. Use the filtering same data table to convert the numbers to uppercase and the amount. Separate the text in word and excel. Automatically wrap the text. Use the summation formula function to draw the standard curve chart and print it. Make projects with multiple worksheets, file directory table, extract zodiac signs according to birthday, merge multiple cells, set text to wrap automatically, increase the number of undo operations, convert numbers from lowercase to uppercase, semicircle bubbles, information chart, enter key cannot wrap, curved surface graphics, chart, move the chart position at will, table can only be viewed, cannot Change the automatic font size adjustment for the circular thermometer chart, create a bubble picture list, convert lowercase to uppercase formulas, and use the read-only mode to open the chart of unequal-width columns, use read-only mode to solve the one-variable equation, draw a beautiful combination chart, create a regression equation curve, create a construction schedule, create a plane rectangular coordinate system, and create a standard Curve chart, plane rectangular coordinate system, worksheet name as title, print only part of the table, double-layer donut chart, triangle stacked column chart, one picture, multiple curve pictures, table to excel cells, multiple rows, and compare two columns of data in one row, similarities and differences, icons, data markers with special Picture competition sorting, automatic scoring table setting, default worksheet quantity, chart coordinates, horizontal axis text, Word table to Excel table, accordion column data chart, click on the table text to learn more~