Hi Gareth,
You could achieve your scenario by binding the
RadPivotGrid and subscribing to its
CellDataBound event. The idea is to use the
e.Cell.ParentRowIndexes and
e.Cell.ParentColumnIndexes and build both x and y axis depending on the values. You could take a look at the example code below to investigate and get the idea how to create a
RadHtmlChart from the pivot grid
CellDataBound event.
HashSet<string> already = new HashSet<string>();
Dictionary<string, ColumnSeries> yAxis = new Dictionary<string, ColumnSeries>();
protected void RadPivotGrid1_CellDataBound(object sender, PivotGridCellDataBoundEventArgs e)
{
PivotGridDataCell dataCell = e.Cell as PivotGridDataCell;
if (dataCell != null && dataCell.CellType == PivotGridDataCellType.DataCell)
{
if (already.Count == 0)
{
this.RadHtmlChart1.PlotArea.XAxis.Items.Clear();
this.RadHtmlChart1.PlotArea.Series.Clear();
}
string rowName = GetName(dataCell.ParentRowIndexes);
string columnName = GetName(dataCell.ParentColumnIndexes);
if (already.Add(columnName))
{
AxisItem axisItem = new AxisItem(columnName);
this.RadHtmlChart1.PlotArea.XAxis.Items.Add(axisItem);
}
ColumnSeries columnSeries = null;
if (yAxis.ContainsKey(rowName))
{
columnSeries = yAxis[rowName];
}
else
{
columnSeries = new ColumnSeries();
yAxis.Add(rowName, columnSeries);
columnSeries.Name = rowName;
this.RadHtmlChart1.PlotArea.Series.Add(columnSeries);
}
SeriesItem item = new SeriesItem();
decimal value = 0;
if (decimal.TryParse(e.Cell.Text, out value))
{
item.YValue = value;
}
else
{
item.YValue = null;
}
columnSeries.Items.Add(item);
}
}
private string GetName(object[] indexes)
{
StringBuilder builder = new StringBuilder();
foreach (object index in indexes)
{
builder.Append(index.ToString());
builder.Append(" / ");
}
builder.Remove(builder.Length - 3, 3);
return builder.ToString();
}
All the best,
Antonio Stoilkov
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their
blog feed now.