Mutilple Series of Chart on Grouping Data

[Sankar]

Hi

We need to plot to two different kind of chart series (Line and Point) on a single report. We are able to achieve it when we don't any grouping but unable to plot correctly when grouping is involved. Please refer the attached snapshot. This is the expected format with grouping.

Data structure:

EmployeeName = "Peter Jackson" , Date = Date 1, MinValue= "60%", MaxValue = "80%" , Average = "70%"
EmployeeName = "Peter Jackson" , Date = Date 2, MinValue= "65%", MaxValue = "90%" , Average = "80%"
EmployeeName = "Peter Jackson" , Date = Date 3, MinValue= "70%", MaxValue = "100%" , Average = "90%"


EmployeeName = "Denis Regan" , Date = Date 1, MinValue= "66%", MaxValue = "86%" , Average = "72%"
EmployeeName = "Denis Regan" , Date = Date 2, MinValue= "68%", MaxValue = "92%" , Average = "85%"
EmployeeName = "Denis Regan" , Date = Date 3, MinValue= "78%", MaxValue = "100%" , Average = "90%"

  
We need to group by EmployeeName on X axis. 
Line Series Data : MinValue and MaxValue
Point Series Data : Average

Please let me know how to achieve this? It would be grateful if you could provide any code samples.

Thanks in advance
Sankar

[Stef]

Hello Sankar,

Please check the answer in your other forum question: Create Scatter Chart using Charting Class .

Regards,
Stef
Telerik