Forum Discussion
Display % Total and Total in same Bar Chart
- 6 years ago
Hi benjikj_mcsp ,
I'm assuming that you only want to show the % as a data label correct? You do not need to have it visualy on the chart?
I would do what you refer creating a combo bar and line chart however with a few adjustments:
- Make you line size to 0 this will give you no line on your chart
- Add data labels for the line values
- Make secondary axis values off
- Make the top bottom values for the sexcondary axis in a way that you can place the % on a location you think is visible
In the example below there is a simple visualization with 3 categories and 3 values but can be adjusted to more:
So as you can see making small adjustments on the visualization data labels and Y-axis is possible to make a similar presentation.
Another option can be use a tooltip.
Hi Anonymous ,
Can you share a sample data and expected result?
The result would look like the pic of the column chart already displayed above but in Bar Chart format. Also want the chart to display the number of people who have picked these choices.(Count)