Jump to content
Software FX Community

How do i create a bar chart with grouped data


dayiku
 Share

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...