I'm trying to do something that should be ridiculously easy and can't get it to work. I want to display a line chart with multiple series that represent similar data. Here is a basic layout of my data:Col1: theTypeCol2: theDateCol3: theQuantityI want to display a line for each type but I don't know the types until runtime.
Mark <><
If you have data in the following format:type valuetype1 0type2 1type2 5type1 2type1 4type1 3type2 6type2 8You need to create a data adapter that will take the above data and create the following data table from it:type value1 value2 value3 value4type1 0 2 4 3type2 1 5 6 8When you plug this into a line chart, you will get 2 lines, with 4 values each.
Hi,
Even I have a similar problem. You have told that we need to group the data manually. How should we proceed from then.
Thanks & Regards -- Sampath
I'm not quite sure how you are trying to display your data. The chart will display one line for each row, using values from numeric columns in that row. In your example, you would get a straight line for each row of data, plotted at Y=theQuantity.I have a feeling, you're expecting the chart to group data based on theType column. So if you have 5 rows, where theType = apple, you'd get a line with 5 points. If so, this is something you will have to do manually, before feeding the data to the chart control. The chart is not capable of doing such grouping.
Perhaps, you could provide a few more details and an illustration of what you're trying to do.