Hello,
I have boiled down my problem to the following simple example:
Here is the table, to which I just bind a select * query.
The end result that I am looking for is a line graph that has a line for each person, showing the progress of weight over time. In an attempt to achieve this, in the wizard, I turned on grouping for the "Name" column. This seems to give the right effect within the wizard, for some reason, the lines don't come out correctly.
Here is the line graph version, which has the lines sitting on top of each other.
Line Graph
Here's a bar graph version, which makes it easier to see what is going on.
Bar Graph
I don't understand why the second series (Jane) has the same values as the first series. Inside the wizard, when I click on the Jane series, the three "series items" for Jane are correct.
I feel like I'm missing some fundamental thing about how the graph is supposed to work. Any help is appreciated.
Thanks,
Stephen
I have boiled down my problem to the following simple example:
Here is the table, to which I just bind a select * query.
Name Date Weight |
John 2008-08-29 300 |
John 2008-09-05 295 |
John 2008-09-10 290 |
Jane 2008-08-29 150 |
Jane 2008-09-05 140 |
Jane 2008-09-10 130 |
The end result that I am looking for is a line graph that has a line for each person, showing the progress of weight over time. In an attempt to achieve this, in the wizard, I turned on grouping for the "Name" column. This seems to give the right effect within the wizard, for some reason, the lines don't come out correctly.
Here is the line graph version, which has the lines sitting on top of each other.
Line Graph
Here's a bar graph version, which makes it easier to see what is going on.
Bar Graph
I don't understand why the second series (Jane) has the same values as the first series. Inside the wizard, when I click on the Jane series, the three "series items" for Jane are correct.
I feel like I'm missing some fundamental thing about how the graph is supposed to work. Any help is appreciated.
Thanks,
Stephen