Forum Discussion

Rahul66303's avatar
Rahul66303
Frequent Visitor
8 years ago

Need help on creating clustered Bar Chart.

Hi,

 

Need a help to create clustered bar chart :

 

This is what i am looking to build

 

Service LineValue 
X2These two values(X,Y) are from one source as covered.
Y2
X27These two values(X,Y) are from another source as BaseLine.
Y16

 

Source table to create Clustered Bar Chart.

Need Help

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    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's avatar
      Rahul66303
      Frequent Visitor
      8 years ago

      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 ?

       

      ServiceLineValue
      X2
      Y16
      X27

       

      Thanks,

      Rahul