Forum Discussion
Solved
Stacked Bar Chart - Percent AND Count
Hello World I'm hoping someone could help. I'm trying to add a count with this stacked bar chart. Here's my visual. Any help would be much appreciated. Kind regards Ray
I don't think this is possible out of the box, but if you have just the one horizontal bar you could try the following hack.
- Create a second chart that is a normal stacked bar
- turn on data labels and set the colour to black
- turn off everything else on this chart (x-axis, y-axis, legend, headers, etc)
- set all of the series to use white as the data color
- then size this chart to match the size of the percentage stacked bar
- send this new chart to the back and position it just a little higher than the original chart
Is there a way to get it to show in the graph? The reason is that I take a screenshot of the graph and put it in powerpoint, so I would like both a percentage and a count to be displayed.
Possible?
Rayinoz
I don't think this is possible out of the box, but if you have just the one horizontal bar you could try the following hack.
- Create a second chart that is a normal stacked bar
- turn on data labels and set the colour to black
- turn off everything else on this chart (x-axis, y-axis, legend, headers, etc)
- set all of the series to use white as the data color
- then size this chart to match the size of the percentage stacked bar
- send this new chart to the back and position it just a little higher than the original chart