I need to show my total using horizontal stacked bar chart

Question & Answer
,
1

Use case:
I have two columns
Example:
Column name – male -10 female-20
I need to show total of these columns using horizontal stacked bar chart without using action ,calculated field ,tooltip and all
It just need to show total at the end of the bars

2

Hi @priyanka1,
If you’re looking to show the totals for each bar, you can achieve that in the ‘format visual’ section under ‘Data Labels’

image
image656×672 27 KB

Unfortunately with stacked bar charts, there is not an option to choose the placement of the labels. But if you were to switch to a regular horizontal bar chart, you could setup the labels to be outside the bars.

image
image675×786 32.6 KB

Let me know if you have any additional questions or if this helps for your case!

1 Like
3

Ok, but I need summation of two columns at the end of the bar and also it should show total count of column1 and column2 in the bars itself using horizontal stacked bar chart.

image
image1244×1892 62.6 KB

Thanks a lot!

4

Hi @priyanka1,
I’m sorry for any confusion on my half; in that case, yes using a horizontal stacked bar chart will work perfect. When you select ‘format visual’, toggle the data labels on. Make sure Label pattern is set to ‘All’ and you check the ‘show totals’ box (See below).
This will provide totals of each metric and the overall total for each group.

image

Let me know if you have any additional quesitons

1 Like
5

Thanks for your reply @Brett . But this total option is only available in horizontal stacked bar chart.

6

Hi @priyanka1,
Yes, in your initial comment you said you need to show the totals of the columns using horizontal stacked bar chart. Have your requirements changed?

7

Hi @priyanka1,
Checking in here as it’s been awhile since we last heard from you. Do you have any additional questions?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

8

Hi @priyanka1,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional topics, feel free to create a new topic in the community and link this discussion for any relevant information that may be needed.

Thank you!

1 Like
9

Hi @Brett
Sorry, I couldn’t reach you!
Yes, we can close the topic.
Thank you so much for your reply!