For this i retrieved the data and put in a List.
PieDataList
PieResult = new PieDataList();
while (reader.Read())
{
PieResult.Add(
new PieData {Naam = reader["Name"].ToString(),Percentage = Convert.ToInt32(reader["Value"])});
}
Later I make sure my data is shown in a Pie Chart.
SeriesMapping
sm = new SeriesMapping();
sm.ItemMappings.Add(
new ItemMapping("Percentage", DataPointMember.YValue));
sm.ItemMappings.Add(
new ItemMapping("Naam", DataPointMember.LegendLabel));
PieChart1.SeriesMappings.Add(sm);
PieChart1.DefaultSeriesDefinition =
new PieSeriesDefinition() { ShowItemLabels = false };
PieChart1.ItemsSource = e.Result;
How can I now change the color of one particular object in my list?
And is it possible to show the values of my objects (Percentage) in the chart?
Kind regards,
Gj