clustered column chart

[Kap]

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.

[Kap]

Thank you @Greg_Deckler and @Anonymous

I will try this.

[Kap]

Thank you @smoupre and @B129.

This trick worked !!!

[Anonymous]

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#

[Greg_Deckler]

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.