Afternoon, I'm having rather a few problems with a) the lack of documentation and b) finding enough examples to fully achieve what I need to do. Here is the scenario right: I'm trying to plot several series on a line chart based on 3 columns - EASY I hear you say; yes if there was more documentation probably :) (No i'm not reading the API documentation before you retort) Column1: Name Column2: Size Column3: Date (this could be any series - count from 1 - 10, date, etc... the column name is dynamic and using Date as an example) What I've previously been doing to bind the several series to the chart is create a pivot (via code) which would create a table with a structure similar to the following (for simplicity I'm only displaying 2 seires);
___________________ |Name| JAN | FEB | MAR | ------------------------------- | ABC | 123 | 456 | 789 |------------------------------- | QRS | 432 | 987 | 654 | ------------------------------- This binds no roblems and serves the purposes sufficiently... The problem comes when I try and bind the RAW data in a DataTable where each row contains a new point for each of the series as below; ________________ | Name | Size | Date | -------------------------- | ABC | 123 | JAN | -------------------------- | ABC | 456 | FEB | -------------------------- | ABC | 789 | MAR | -------------------------- | QRS | 432 | JAN | -------------------------- | QRS | 987 | FEB | -------------------------- | QRS | 654 | MAR | -------------------------- How am I supposed to plot each of the series onto the line chart; bearing in mind that thsi is a VERY small section of data and there could be many more series and far more points as I've mentioned here... I can't loop through the data table creating a new Point() each time and then assuming how many points should be in it. I need something similar to the way that the pie chart or bar chart by setting specifically the time column, the value column and the series column.... The example I saw but didn't help much as I could not find anything in the documentation to help with this: http://forums.infragistics.com/forums/p/1508/12494.aspx#12494
Unfortunately, the line chart doesn't have a mechanism to interprete such snapshots of data. I don't see any other way than either creating a pivot table or creating a series for each new value in the Name column and adding numeric points to that series. While I don't know how large your data really is, but creating 100 series with 1000 points each takes a split second. Rendering this much data will take at least 6-7 seconds. So I think that looping through the data should be less of a concern, than the amount of data that the chart will be able to handle.