Before you start: if your worksheets are identical, it's probably easier to create 3D-references (if you have one workbook) or External References (if you have multiple workbooks) to consolidate your data. However, the beauty of the Consolidate feature is that it can easily sum, count, average, etc this data by looking at the labels.
Because our worksheets are not identical, we want Excel to sum cells that have the same labels.
As you open the Consolidate Survey dialog box, all survey questions will be loaded (provided the survey had been created with Consolidator Enterprise Version 1.5.0 or higher).
Otherwise, you will have to load the questions manually.
For a number of reasons, however, pie charts are not as effective as bar or column charts.
Their sole benefit is that they show each category's proportion of the total of all categories. While proportions are shown graphically in a pie chart, except for proportions of 25% or 50%, it is not easy to visually determine what these proportions are, unless data labels are used to show the percentages.
If you need to merge the data of two separate surveys, export the data for each survey and try combining the files in Excel.
Change the word Sheet in the formula to match the text part of the name of your sheets.
Also assumed that you coincide the rows with the rows of each data sheet.
You can use Excel's Consolidate feature to consolidate your worksheets (located in one workbook or multiple workbooks) into one worksheet. If you check Create links to source data, Excel creates a link to your source data (your consolidated data will be updated if your source data changes) and creates an outline.
Below you can find the workbooks of three districts.