How Do I create a comparison Bar Chart Showing 2 Bars for Each Value

[#1]

Hi 

I am trying to create a chart based on this data and would like the Number of Teddy Bear Accounts to be shown right next the Number of Non-Teddy Bear Accounts for each client type:

CommunityBank:

LOAD [Business Units],

     [Type of Client],

     [Number of Teddy Bear Accounts],

     [Number of Non-Teddy Bear Accounts]

I have managed to create a barchart but they are stacked one on top of the other.  Is there anyway I can make them show side by side?

Your help would be much appreciated.

Thank you.

[gussfish]

Hi Natasha,

open up your chart's properties (right click on the chart & select

Properties) and go to the Style tab. There you'll find radio buttons to

change your chart from Stacked to Grouped.

Angus.

[rahulgupta · Accepted solution]

Hey hi Natasha,

Please check:

Dimentions In your Chart:

1. [Type Of Client]

Expression in your chart:

1. Sum( [Number of Teddy Bear Accounts])

2. Sum( [Number of Non-Teddy Bear Accounts])

Style Tab:

1. Grouped (Agree with Angus)

Hope thi helps

Regards

[#4]

Thank you, Rahul, it works now.  My error was in 'Dimensions'.  Until I changed that, clicking on 'Grouped' did not work.

[rahulgupta]

My Pleasure....