21 Replies Latest reply: Jan 9, 2017 7:08 AM by sunny sahnj

# Count in Bar Chart Legend

Hi,

Is it possible to show the count of values in a bar chart legend? Something like the following

Thanks,

Sunny

• ###### Re: Count in Bar Chart Legend

can you please give more details

• ###### Re: Count in Bar Chart Legend

Nothing is there in following.

• ###### Re: Count in Bar Chart Legend

something like this, not sure if the image is visible

• ###### Re: Count in Bar Chart Legend

Boss, If you have only one Expression you can't make legend in Bar Chart.

Come to Bulk Expressions, You need to paste the Same Expression into Label and then Show what ever you want

• ###### Re: Count in Bar Chart Legend

Hi Sunny

If you have limited legends or fixed legends to show then it is possible , as following

lets say you have bar chart like

Then you will have to create expression for each Year legend individually.

Once you have that, you can put count or other calculation in its label

As shown here,

• ###### Re: Count in Bar Chart Legend

Thanks Giri,

I was able to get this pretty easily in a pie chart using the presentation tab in properties. But I can't find that function in the bar chart.

Any simpler way of showing the count?

I need to show the count of issues by department and year, e.g. HR has 10 issues, IT 20 issues, etc. and I have it in a stacked chart. Thoughts?

Thanks

• ###### Re: Count in Bar Chart Legend

But there is no calculations in the legend?

Or do you wish result on data points?

• ###### Re: Count in Bar Chart Legend

I just want the count in the legend like it shows

• ###### Re: Count in Bar Chart Legend

so you are not looking for something like

When you mentionedd Stack chart, I am wondering how/where do you want to put numbers in it?

• ###### Re: Count in Bar Chart Legend

This works too, how did you get this?

I just have 1 expression which is Count(Issue)

Dimensions are Year and Department

and it's a stacked bar chart

• ###### Re: Count in Bar Chart Legend

I am guessing:

• ###### Re: Count in Bar Chart Legend

I tried that, it's a stacked chart, it just gives me the total of all the departments, I need to show it next to the department like in the pie chart I put up above

• ###### Re: Count in Bar Chart Legend

Strange, Can you send you application to work on it. If the file size is large then you make reduce size and then share with us it demonstrates the Output

1) Have you created Label for Numbers on each expressions ?

• ###### Re: Count in Bar Chart Legend

sorry I can't send the application, it's confidential.

I just have 1 expression which is Count(Issue)

Dimensions are Year and Department

Stacked bar chart

I did something similar in pie chart and was able to get the count easily. Am I missing something?

• ###### Re: Count in Bar Chart Legend

When you say you are trying for Pie Chart you should do this to show Numbers, I mean share only scramble data. You may go ahead and create one file for Us and then it will show the issue for Sure always

Please check which i high-lighted the below image

• ###### Re: Count in Bar Chart Legend

Hi

So earlier I suggested to put each individual expression and then put count in label for each. But if you don't want to go that way and you have many departments to show,

I guess something like following would help. Lets see if that gives you desired result.

eg. you have

then change the dimension to calculated as following

should get you this result

• ###### Re: Count in Bar Chart Legend

Thanks Giri,

This is what I wanted. Just curious how did you get the following numbers in the bars

• ###### Re: Count in Bar Chart Legend

for legends you do the calculated one as I showed

For inside chart numbers you need following two properties to be checked