Forum Discussion

Kap's avatar
Kap
Regular Visitor
10 years ago

clustered column chart

Hi,

 

I have a requirement to create 'clustered column chart'. In that I have to have 2 columns at the X-axis.

 

Ex: On X-axis I should have Region and City. Cities should be grouped under respective region and show sales data.

 

Please help me with this.

 

Thank you.

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    10 years ago

    With a clustered column chart, if you put two things in the x-axis, you will be able to "drill into" the columns. Alternatively, place Region in x-axis and Cities in Legend, then you will get both on the x-axis grouped by region.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi Kap,

     

       here is an example of what Greg_Deckler tolds you.

    (I've used state/city to simplify)

     

     

    I've changed the "Date Category" of State and City to make them more efficient.

     

    #I'M Not An Expert#