Solved

Excel data in pie charts

Posted on 2013-06-06
8
581 Views
Last Modified: 2013-06-07
In Excel I can easily make a 3-d pie chart following the help in the application. But I need to add more data values to the chart and cant seem to know how to do that.

If I select 2 columns of data for example:

Sandwiches      40
Salads                          21
Soup                          15
Beverages       9
Desserts                         15

That will put it into a pie chart and have the coorosponding percentages. Bbut I need more than just the percentages, I also need another value. How do I add it?
I tried makeing 3 colums, as the 3rd column being the additional data but it wont make a pie chart.
Thanks.
0
Comment
Question by:tolinrome
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 7

Expert Comment

by:dec0mpile
ID: 39226731
This is a limitation of the type of chart you are using. A pie chart is a percentage chart, so only one series of data will be used in the chart.

You have to pick a different type of chart to use multiple columns.
0
 
LVL 30

Expert Comment

by:captain
ID: 39226732
If you right click you can modify the data labels. percentage is a standard option so you could have your data displayed in column 2 and add % via the data label format.
0
 
LVL 7

Author Comment

by:tolinrome
ID: 39226897
I tried both ways in both responses but couldnt seem to get it to work.

What I need is:

Column A     Column B       Column C
Server 1          30%                   129GB
Server 2          17%                   23GB
Server 3           28%                  12GB

Just like that above.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 39227028
In your example above, what does Col B even represent?  Can't be percent of the whole, because based on Col C, Server 1 should have ~80% of the whole.

Let's take a step back.  Please describe, in a few sentences, what it is that you are trying to visualize.  That will help us understand whether a pie chart even makes sense for your situation.

(Not to mention that most data visualization experts discourage use of pie charts generally, as most of the time there are better ways to represent your data anyway...)
0
 
LVL 7

Author Comment

by:tolinrome
ID: 39227093
ok, thanks. Those percentage and GB numbers werent meant to be accurate, just an example of what I wish to present.

I have 3 columns, one is the folder name, one is the Gigabytes (datasize) of the folder, and the 3rd is the percentage of that data in the folder.

Other than pie charts or bar graphs, what other ways are best to present the data according to the data visualization experts?
0
 
LVL 7

Author Comment

by:tolinrome
ID: 39227127
Youre right, bar graphs look better
0
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 39227518
Please see the attached file:

Q-28149974.xlsx

If you want to go with a pie chart, you do not need the percent column: Excel will automatically size the segments in the chart such that the area of each segment is proportional to that item's share of the total.  If you add data labels for a pie chart, there are options that allow you to show the value and/or percentage share.

I would go with a column chart, although this does mean you would need a percentage column.  In my example column chart, I changed the formatting for the Pct series to use no fill and no border, but I did show the data table so you could see the value and percentage share.

There are a number of reasons why pie charts are bad.  Here are some of them:
The human visual system is just not very good at comparing the relative sizes of segments of a circle
Once you have more than 2 segments, pie charts can be hard to read
Do not even think about using a 3-d pie chart!
0
 
LVL 7

Author Closing Comment

by:tolinrome
ID: 39230604
Excellent. Graphs\Bar charts are way better than pie.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read this checklist to learn more about the 15 things you should never include in an email signature.
Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question