WizKid Posted February 13, 2008 Report Share Posted February 13, 2008 Hi, I have a Dailly chart with the days of the week on the X-axis, No. of users in a team on Y-axis. I have many such teams. I am trying to have a line chart with each team representing a line in a separate color, but without any success. For Example I have the following columns in my dataset which are grouped by the team name. ----Day --- No. of Users----- TeamName--- Sun 4 A Mon 5 A Tue 2 A Sun 7 B Tue 1 B Mon 6 C Any help is appreciated!!! Thanks...... Link to comment Share on other sites More sharing options...
Frank Posted February 13, 2008 Report Share Posted February 13, 2008 You need to use the CrossTab data provider. The easiest way to do this is through the Data Wizard, simply select these three columns and the grouping options will be given to you. For a code example on using the CrossTab provider please refer to the programmer's guide under Passing Data -> Crosstab DataProvider. Link to comment Share on other sites More sharing options...
WizKid Posted February 13, 2008 Author Report Share Posted February 13, 2008 Yeah that did the trick. Thanks A Lot!!! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.