13 Replies Latest reply on Sep 24, 2019 11:31 PM by Aditi Raizada

# Compare the value of two bars within Side-By-Side bar graph

Hello Folks,

I wanted to compare the two bars with each other. If you see the image, I want to compare the profit of one bar(bookcases) with another bar(chair).

Please help me if there is a way out to get the solution.

Thanks in advance.

• ###### 1. Re: Compare the value of two bars within Side-By-Side bar graph

Your description is a bit confusing. Can you please show/draw a rough schematic of what you anticipate, the final outcome...

• ###### 2. Re: Compare the value of two bars within Side-By-Side bar graph

Hi Vikram,

I want to compare the profit between, bookcases and chairs. If the bookcases profit is greater than chairs, I will perform some calculation. I am figuring out a way to get the exact value here, in this case, the value of bookcases and chairs. Is there a formula which I can implement here?

Thanks.

• ###### 3. Re: Compare the value of two bars within Side-By-Side bar graph

Ok, so comparison has to be between only specifically book cases and chairs ? or it could be any two/more ?

• ###### 4. Re: Compare the value of two bars within Side-By-Side bar graph

Hi Vikram,

Apologies for the late reply. I have the condition where I have to compare the two bars. So want to compare between 2010 and 2011 across for all products. Thanks.

• ###### 5. Re: Compare the value of two bars within Side-By-Side bar graph

Like this ? Attached is the TWBX...

• ###### 6. Re: Compare the value of two bars within Side-By-Side bar graph

Add sub-cat and year to column

and Profit in rows.

Image is shown for your refrence

• ###### 7. Re: Compare the value of two bars within Side-By-Side bar graph

Hi Vikarm,

Thanks for your reply. I am sorry to say but this is not what the solution I am looking for. I meant, if I have two bars, for example, one is 2010 and other is 2011, for product 1. Than I want to compare the value in the sense of getting the value of (product1.2010) and the value of (product1.2011). In other words, if I have set an index 0 for 2010 and index 1 for 2011, then I want the value of index0 and index1.

Thanks.

• ###### 8. Re: Compare the value of two bars within Side-By-Side bar graph

Hi Aditi,

Thanks for your reply. I am sorry to say but this is not what the solution I am looking for. I meant, if I have two bars, for example, one is 2010 and other is 2011, for product 1. Than I want to compare the value in the sense of getting the value of (product1.2010) and the value of (product1.2011). In other words, if I have set an index 0 for 2010 and index 1 for 2011, then I want the value of index0 and index1.

Thanks.

• ###### 9. Re: Compare the value of two bars within Side-By-Side bar graph

Sorry for late rply. Just wanted to confirm that you basically want value of profit of a product in year 2010 and 2011.

• ###### 10. Re: Compare the value of two bars within Side-By-Side bar graph

Hi Aditi,

Let me explain it to you. I have side-by-side graph where I have used index. The first two bars for product1, i.e, index o and index 1,  I need to get the values of them.

So If I have three products, then I will have 6 bars, which would be index 0 to index 5, I need to have the value of each index, so that I can perform some calculations.

Thanks.

• ###### 11. Re: Compare the value of two bars within Side-By-Side bar graph

like this.

• ###### 12. Re: Compare the value of two bars within Side-By-Side bar graph

Hi Aditi,

Thanks for your reply.

You have plotted on the view as a text table. In my case, I have a side-by-side bars, with indexes placed on them. I need to get the value of index 0 and index 1, so that I can perform further calculations on them.

The same way, it will be done for index 2 - index 5.

Thanks.

• ###### 13. Re: Compare the value of two bars within Side-By-Side bar graph

Hey Shaibaz Mulla!

I have made the bar graph plot with index.

i have also attached dashboard for your refrence.