tolinrome
asked on
Excel data in pie charts
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.
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.
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.
ASKER
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.
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.
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...)
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...)
ASKER
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?
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?
ASKER
Youre right, bar graphs look better
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent. Graphs\Bar charts are way better than pie.
You have to pick a different type of chart to use multiple columns.