Orly Gonzalez
New Member
- Joined
- Oct 25, 2009
- Messages
- 1
Dear friends:
I'm trying to create a horizontal 100% stacked bar chart in Excel 2007. The pivot table which the data comes from displays the counts of several categories, and I must create several dynamic tables displaying only the count of each category as integer numbers, not as percentages. But, when I created the bar chart, I realized that it hasn't the option to display the values on the bar as percentages (as in the pie chart), but as shown on the pivot table. More graphically, I want that the data in one row like
Level Option 1 Option 2 Option 3 Option 4
HS 1 3 12 40
...
would be displayed, by Data labels, on the stacked bar chart as
HS 2% 5% 21% 72%
...
I tried through "Custom number format", but I failed...
May I request your help in this problem? Is there a way to do that?
Thanks in advance for your help and support.
Best regards,
Orly Gonzalez
I'm trying to create a horizontal 100% stacked bar chart in Excel 2007. The pivot table which the data comes from displays the counts of several categories, and I must create several dynamic tables displaying only the count of each category as integer numbers, not as percentages. But, when I created the bar chart, I realized that it hasn't the option to display the values on the bar as percentages (as in the pie chart), but as shown on the pivot table. More graphically, I want that the data in one row like
Level Option 1 Option 2 Option 3 Option 4
HS 1 3 12 40
...
would be displayed, by Data labels, on the stacked bar chart as
HS 2% 5% 21% 72%
...
I tried through "Custom number format", but I failed...
May I request your help in this problem? Is there a way to do that?
Thanks in advance for your help and support.
Best regards,
Orly Gonzalez
