WizKid

Hello, I have a bar chart. It has the data set as follows. I am using VB.NET 2.0 ID Forum No. of Users 1 ABC 5 2 DEF 3 3 GHI Null 4 JKL Null I have each forum displayed in a different color in the bar chart. I also have the legend boxes enabled. But they show all the forum names irrespective of the data in the "No. of Users" column. I want the legend boxes to show up for only the first two forums which have non null values for "No. of users". Even though there are only two bars in the above chart but all legend boxes show up for all forums. How can I control the display of legend boxes based on the column values. Also when there is no data in the chart how do i display a message in the chart saying "No data available" Thanks.....

I used a Data tab provider for the line chart. If I have my result in the dataset as: Day No. of Users Team ---- -------------- ----- Sun 5 A Tue 4 A Mon 7 B I have the teams with lines having different color in the graph.Days are on the X-axis and no. of users on the Y-axis When the result is grouped by name like above the chart shows the X-axis as: Sun Tue Mon Here Sun and Tue points are joined for Team A line and Team B is represented in the form of a dot. The days on the x-axis are not in order. And when I GROUP then by day and not team Day No. of Users Team --- ------------- ----- Sun 5 A Mon 7 B Tue 4 A I have the x-axis now in order. Sun Mon Tue But in this case the line for team A is not connected between Mon and Tue. It just shows two dots one on Sun and other on Tue. And a dot is also shown for B on Mon. My question is how to have a contineous line connect points for Team A and also the X-axis days are ordered. Please Help. Thanks!!!

Yeah that did the trick. Thanks A Lot!!!

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......