how to make a pie chart in excel with non adjacent ranges

A box opens, as shown in the following image.

Right-click on the blank chart area and click “Select Data.”.

Select a 2D clustered column chart from the various column charts in excel.

Now, we insert a column chart using the named ranges.

With this, we have created two dynamic chart ranges–“Salary_Range” and “Profession_Range.” A dynamic chart range for the profession column is created.

Click on “Name Manager” again and apply the formula shown in the following image.

This is because, in the presence of blank cells, the OFFSET function will not do accurate calculations. Note: While creating a name range, there should not be any blank values. A dynamic chart range for the salary column is created.

After clicking on “Name Manager” in Excel, apply the formula shown in the succeeding image.

In the Formulas tab, select “Name Manager.”.

Here we discuss how to create Pie Chart in Excel along with practical examples and a downloadable excel template.

This has been a guide to Pie Chart in Excel. If there are too many values, try using a column chart instead. If the labels are fewer, less we can compare easily with the other slices.Try to explore each slice by a maximum of 8%.Use a different color for each slice and make the chart look beautiful to watch.

This will be very much understandable to the users.

Instead of using legends, try to show them along with the data labels.

3D chart significantly distorts the message.

If there are too many things to show, it will make the chart look ugly.

Fitting data labels in the case of smaller values is very difficult.

Easy and no need to explain it to the end-user.

With the help of each slice bar, we can easily compare one with another.

Large data can be presented by using the Pie Chart in Excel.

Step 6: Similarly, we can change the color of each bar, change the legends space, adjust the data label show etc.… Finally, your chart looks presentable to the reader or the user. We can change these data labels’ alignment to center, inside end, outside end, Best fit. We can show the series name along with their values, percentages. Step 4: Select the data labels we have added and right-click and select Format Data Labels. This will add all the values we are showing on the slices of the pie. Step 3: Right-click on the pie and select Add Data Labels.

Step 2: Now, it instantly creates the 3-D pie chart for you.

TEXT and String Functions in Excel (26+).

Lookup and Reference Functions in Excel (35+).

How to make a pie chart in excel with non adjacent ranges