Hello all -
I have a quick question about series. Given the following result set:
|
Content Knowledge Other Supervisor 3.846153 |
Content Knowledge Peer 4.423076 |
Content Knowledge Primary Supervisor 4.571428 |
Content Knowledge Self 4.000000 |
Cross Cultural Intelligence Other Supervisor 3.933333 |
Cross Cultural Intelligence Peer 4.941176 |
Cross Cultural Intelligence Primary Supervisor 5.000000 |
Cross Cultural Intelligence Self 4.333333 |
Emotional Intelligence Other Supervisor 4.375000 |
Emotional Intelligence Peer 4.363636 |
Emotional Intelligence Primary Supervisor 5.000000 |
Emotional Intelligence Self 3.888888 |
Leadership Attributes Other Supervisor 4.045454 |
Leadership Attributes Peer 4.157894 |
Leadership Attributes Primary Supervisor 4.916666 |
Leadership Attributes Self 4.083333 |
Social Intelligence Other Supervisor 4.050000 |
Social Intelligence Peer 4.625000 |
Social Intelligence Primary Supervisor 4.181818 |
Social Intelligence Self 4.200000 |
Is it possible to auto generate the series rather than having to create them manually? In this example there should be 4 series (Self, Peer, Other Supervisor, Primary Supervisor). The x-axis grouping should be Content Knowledge, Emotional Intelligence, etc. The y data value should be average score.
It seems if I don't manually create the series but only set the following properties on the chart object, it will create the series for me automatically but it is always of type bar chart and I need a line chart.
|
chart1.DataGroupColumn = "RaterType"; |
chart1.Legend.Appearance.GroupNameFormat = "#VALUE"; |
chart1.PlotArea.XAxis.DataLabelsColumn = "QuestionSetName"; |
Having to create the series manually seems like a lot of work. Any insight to this matter will be greatly appreciated.
Thanks!