Pie Charts are used widely in the Microsoft Excel community but for the wrong analysis.

Even though pies are delicious!, a Pie Chart should only be used to show several parts that make up a whole, for example, a product cost breakdown, margin breakdown or the market share of companies.

DOWNLOAD WORKBOOK

Pie Chart

Helpful Resource:

MOTH 468x90.update.your.skills.animated.chart.learn.online.2

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Combine Column & Line Charts in Excel Some times you may come across a situation where you want to show 2 variables in one Excel chart. For example, you may have some sales data and a transactional count that you want to show in one chart to see if there is any relationship between the two variables. Well you c...
100% Stacked Column Chart: Percentage Contribution... The 100% Stacked Column chart is an extension of the Stacked Column chart in that it compares the percentage that each value contributes to a Total. For example, if you want to show the percentage contributions for the North & South sales over the last 5 years then thi...
Create a Sunburst Chart With Excel 2016 Sunburst Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you hierarchical data, like having a table with different levels of categorization: Each hierarchy is drawn by one ring in the sunburst chart. The inn...
Dotted Line Organizational Charts You can create Organizational Charts in Excel using SmartArt which I go through in this post here:   Organizational Charts in Excel You can also extend this concept to create a Dotted Line Organizational Chart but we need to think outside the square a little bit to make this h...