Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
 Posted - 2010-07-30 : 04:53:53
|
| I have two line charts within a report both plotting very simular data. They both have the marker plots however on the first chart the 4 series lines have markers which are joined with lines as expected. On the second chart it has the 2 series lines with markers but only some of the series markers are joined with lines? All my data is valid and does not contain NULL values.When you look at the chart the markers that are joined together with a line almost look like the data points are slightly closer together maybe. While the markers that are not joined by a line which is most fo them look a little further apart. This could just be the screen as the data plots are very close to 30 seconds apart each time.Any ideas, I have spent a long time comaparing the two graphs and cannot see any differences. |
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2010-08-01 : 23:14:34
|
| The problem here was because the data stored in the table for the three different series data were not stored with exactly the same time stamp. I don't understand why it is a problem but it is. Series field is Name, Data field is Value and Category field is Time.Here is an example of what was causing the plots not to be joined by lines.Time Name Value2010-08-02 12:00:00.100 1 1002010-08-02 12:00:00.101 2 2002010-08-02 12:00:00.105 3 3002010-08-02 12:00:00.110 1 1002010-08-02 12:00:00.111 2 2002010-08-02 12:00:00.112 3 300So I changed so the data is stored as such and it fixes the issue.Time Name Value2010-08-02 12:00:00.100 1 1002010-08-02 12:00:00.100 2 2002010-08-02 12:00:00.100 3 3002010-08-02 12:00:00.110 1 1002010-08-02 12:00:00.110 2 2002010-08-02 12:00:00.110 3 300 |
 |
|
|
|
|
|
Line chart not joining dots on series