How do i create a bar chart with grouped data

[dayiku]

I have a bar chart with data that has been grouped.

e.g Number of oranges and bananas sold each month

On the x axis I want to have oranges & bananas grouped together, so that i can compare how many were sold in each month.

Along the x axis will have the months listed.

 

Can somebody tell me how to do this?

 

Thanks

[Frank]

You need to series, one for bananas and one for oranges.

 

Depending onhow your data is organized (if you are using Data Binding) one of the following two options will be the one for you:

1) If your data comes in the following form:

Date   Bananas Oranges

1/1/2009  100 200

1/2/2009 200 350

....

Then all you have to do is bind the chart to this table. The default bindings will do what you need.

2) If your data comes in the following format:

Date   Fruit Sales

1/1/2009 Bananas   100

1/1/2009  Oranges 200

1/2/2009  Bananas 200

1/2/2009  Oranges 350

...

Then you canuse the CrossTabdata provider (see resource center for more info).

In either case, you can use the Data Wizard at design-time to guide you through the process.