Need help on creating clustered Bar Chart.

[Rahul66303]

Hi,

Need a help to create clustered bar chart :

This is what i am looking to build

Service Line	Value
X	2	These two values(X,Y) are from one source as covered.
Y	2
X	27	These two values(X,Y) are from another source as BaseLine.
Y	16

Source table to create Clustered Bar Chart.

[Zubair_Muhammad]

Hi @Rahul66303

Here is one trick

Place the Value field twice in the VALUE section.

First take the Max of Value

Then take the Min of Value

[Rahul66303]

Hi Zubair_Muhammad,

Thanks for the solution,but how to prevent if any of the case i am getting only 1 value for x or y ?

ServiceLine	Value
X	2
Y	16
X	27

Thanks,

Rahul