create pie chart in excel using different data

Keep selecting the chart, click Design > Add Chart Element > Legend, and then select a legend option from the submenu. Click the OK button to close the Select Data Source dialog box.Ĩ.

In the Select Data Source dialog box, click the Edit button in the Horizontal (Category) Axis Labels section to open the Axis Labels dialog box, and then specify the axis labels as you need, and click the OK button. Finally, all added data series from worksheets are listing in the Legend Entries (Series) box as below screenshot shown.Ħ.

When it returns to the Select Data Source dialog box, repeat step 3 and step 4 to add data series from other worksheets. And in the Edit Series dialog box, specify the series name and series values from a worksheet, and then click the OK button.ĥ. In the opening Select Data Source dialog box, click the Add button.Ĥ. Right click the blank chart, and select Select Data from the right-clicking menu. Click Insert > Insert Column Chart (or Column)> Clustered Column. You can follow below steps to archive it.ġ. This section is talking about creating a column chart with extracting many data series from multiple worksheets in Excel.

Create pie chart in excel using different data