create pie chart in excel using different data

Convert the pie values in to a bubble chart.

You can do them by using Excel’s bubble chart. Here we will see 9 creative ways to alter your pie charts so that they can start a conversation.īottom aligned bubbles are a new fad in visualization. Well, you don’t really want them to like your charts, you want them to like your insights, your ideas.īut, to get there, you need to shake up your audience, so that they take notice of what your charts are saying.Ī simple trick for achieving this is showing charts in different formats (while retaining the meaning). You thought your audience are going to love it.īut your pie charts failed to evoke any response. You have included several pie charts since they are easy to digest. You have analyzed the data so well to arrive at some really amazing conclusions.

They should get rid of them and save you a lot of manual deletion.You have made an impressive presentation with lots of data and charts. If you noticed that you’ve entered the same data multiple times after creating your pie chart (a common mistake) you can try some of the formulas in our how to find duplicates in Excel guide. We even have a dedicated bar graph in Excel guide to help you make one.Įxtra: How to Find Duplicates in Excel Data and Remove Them If you realized that a pie chart doesn’t really work with your data set, chances are you can’t go wrong with a trusty bar graph.

The smallest sections of your pie will be automatically split into a bar chart.

The option is in 2-D pie settings, next to the pie in pie icon.

Select your data, click the pie icon, and choose the Bar of Pie chart option.

This is quite useful, as it lets viewers more easily see the differences between them: Alternatively, you can create a Bar of Pie chart, which as you may expect displays a small bar chart next to your data for the smallest.

Create pie chart in excel using different data