Is there a way to compose a chart that will let you show how many times one number goes into the next. For example 3 into 4 is 75%. How can I display the 4 as 100% in the pie chart? This may be an easy answer and perhaps I have been spending too many hours on the computer. Any help would be greatly appreciated! Thank You
Hi KamranZand,
You could try adding another column that calculates the percentages for you?
Say, A1 = 3, B1 = 4, C1 = A1/B1 = 0.75. Display C1 as a percentage by right clicking > format cell > number > percentage.
Then plot the percentage? Hope this helps
Did I help? Click *- add to my rep.
I don't use pie charts, but here is basically how a pie chart thinks:
1) A pie chart doesn't see the inputs as percentages, it sees them as numbers.
2) A pie chart takes all the inputs and sums them, then declares this value 100% [sum(x's)/sum(x's)=1]
3) It then takes the individual data point and calculates each point as a percentage of the total [x/sum(x's)=percentage for this point]
In your case, you essentially want to specify what sum(x's) should be, then show a pie chart based on that sum. Here's how I'd probably set it up (comma delimited)Then plot C3:C4 as a pie chart.
Please Login or Register to view this content.
Originally Posted by shg
Aah! Thank You so much! Makes Sense!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks