Pie charts in excel 2010

[HNoel33]

Good morning,
Need major help please.

I am trying to create a pie chart in EXCEL 2010

I have a total number of 4143.... (lets say of hamburgers)
Then i have a listing of the number of hamburgers with cheese, # of hamburgers with tomotoes, # of ham. w lettuce, etc...

Now i can create a pie chart with the percentages of burgers with each item - but how do i include them off the 4143 total?

e.g.
My chart shows
Hamburgers w cheese - 93%
Tomatoes - 2 %

But i want the percentage to run off the total 4143....

How do i do this?

Thank you and i apologize for the mass confusion if there is any

[GeneralDisarray]

ok. Cick on the chart (assuming you have a chart made) and go to the Chart Tools > Design tab.

The "Chart Tools" tabs show up with you select the chart. Select the proper "Chart Layout" from the design tab.

THere are multiple % options...

[Pepe Le Mokko]

If you search the web you'll find that pie charts have a lot of drawbacks

[HNoel33]

Book1.xlsOkay -THANK YOU SO much for your quick response.
I can get to the design tab and such... i can even create the chart... however.. my percentages are not pulling from the total i have
I copied my info below.
I want everything under the Asset Total to pull from my 4143 number...
How do i fix it to do that? ( i have also attached a sample of what i am looking at)


Asset Total 4143Active 2783
Destroyed 7
Disposed 4
Disposed Of 2
Donated/Sold 6
In Inventory 0
Inactive 12
Open Inventory 55
Pending Disposal 23
Pending Initial Use 48
Received 50
Sanitized 0
Surplus 6
Training 2

[HNoel33]

Excel, from my understanding in general, has a lot of drawbacks...

Regardless - I am still determined to learn how to do this properly. I have gotten so much out of this forum...it is AMAZING.

[GeneralDisarray]

can you upload an example please? select the "go advanced" (next to the post quick reply option) and then look for the "manage attachments" button.


That will give you a way to "Select Files" and then Upload the file.

[HNoel33]

Book1.xls
General - Yes - I placed a sample in my last reply to you... Book1
i see it in there - ...

i have attached it again
thank you

[GeneralDisarray]

See attachment.

You will need to add a column - your percentage is not based on the sum of values in the chart. The new column will calculate the percentages for you.


Also, pie chart is a bad idea with this much data and slices so small... maybe try a bar chart? Examples of both attached.

[HNoel33]

See attachment.

You will need to add a column - your percentage is not based on the sum of values in the chart. The new column will calculate the percentages for you.


Also, pie chart is a bad idea with this much data and slices so small... maybe try a bar chart? Examples of both attached.

GOODNESS!!! I got it!!! thank u thank u~!!
You have made my Monday!
I love being able to learn new things!! Lol
Thank you again!!

[HNoel33]

now how do i close this one ? thread i mean...

[GeneralDisarray]

(This and other answers can be found in the FAQ section for the forum)

Mark Your Thread Solved
To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

[HNoel33]

thank you again General!! Have a great day!