![]() Assuming my original data table started in cell A1 and my new data table starts in cell F1, my new data table values have formulas like this: =B2/SUM(B$2:B$6) and the values are formatted as a %. ![]() “I copied the set of provided data into my workbook, and then made an identical table next to it to show the relative percentages. ![]() I had one super fan (PETE) that got this right and he taught me a thing or two by saving me a step from my original posting. If Sandra has 3 apples 1 orange and 1 banana, can I show within each block of her stacked chart 3 (60%), 1 (20%), and 1 (20%) respectively as opposed to only a number or only a percentage? Thanks a lot for any help! ![]() Is it possible to list both a numeric value and its percentage within each block of a 100% stacked chart? For example let’s say I’m trying to show how many Apples, Oranges, and Bananas (Y) that Sandra, Susie, Jamie, Jorge, and Alberto each have (x). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |