how to make a pie chart in excel with multiple columns

In the Charts group, choose the first 2-D column chart in the Chart dropdown.

To illustrate, create a quick column chart as follows:

Click OK and Excel will format the data range as a table.Īny chart you build on the table will be dynamic.

If the table does not have headers, be sure to uncheck the My Table Has Headers option.

Excel will display the selected range, which you can change.

To do so, simply select the data range and do the following: LEARN MORE: Office 365 Consumer pricing and features The table methodįirst, we’ll use the table feature, available in Excel 20–you’ll be amazed at how simple it is. Fortunately, the process is easy to implement in Excel 20 if you’re willing to use the table feature. By doing so, the chart will automatically reflect changes and additions to the source data.

The key is to define the chart’s source data as a dynamic range.

If you want to advance beyond your ordinary spreadsheet skills, creating dynamic charts is a good place to begin that journey. The steps are very similar to the following tutorial by Susan Harkins. Editor’s note: In the video, Brandon Vigliarolo uses Microsoft Office 365 and walks through the steps of building dynamic charts in Excel.

How to make a pie chart in excel with multiple columns