Possible to show stackedbar datatable AND a stacked bar total in chart?

[Derek]

My developers are constructing a stacked bar chart, and have included a datatable to show the values of the stacked elements. The user has also asked to see the total value for each stacked bar. There are references to changing the label of the last series to show the total, using STSUM, but it appears this also changes the display in the datatable (so that the last series shows the total in the datatable as well).

Any suggestions on including BOTH the datatable and a stacked bar total, either in the datatable or as a label on the bar?

Alternatively is it possible to have a bar value which shows in the datatable but NOT in the chart?

TIA

[Ves]

Hi Derek,

You can add an additional ChartSeries with Name="Total" and the same number of ChartSeriesItems as the other ChartSeries, but all of these items should have YValue=0. This ChartSeries will be used to display an entry in the datatable and possibly some labels in the plotarea. Set its DefaultLabelValue with "#STSUM" and you will have the required DataTable entry.

Now, the labels of this "total" series will overlap with other stackedbar labels, so you can set the IntelligentLabelsEnabled property to true. As long as the chart is not overloaded with items this will work fine and the total will appear above the other values. However, when more labels are displayed this might not yield the best expected result, so I would suggest hiding the total labels, the values will remain visible in the datatable.

Hope this helps.

Best regards,
Ves
the Telerik team