Hello,
I have been slowly replacing our RadChart controls with the new RadHtmlChart with small issues here and there as I have posted on the forums. I have come across a couple of additional issues while trying to replace some of our stacked bar charts.
Below is the HTML markup for the chart that I am trying to implement which is a column series with the property for stacked on the first series set to true as indicated by the documentation on how to create a stacked chart. However, the rendering of the chart does not produce the intended results. Although the columns do stack on one another, the YAxis max value is a much larger number than what it needs to be. This causes the bars to be small compared to the chart and hard to distinguish the stacks series. For instance, the data being returned in this case would not cause a stacked bar to have a total of more than about 90 to 100. When the chart renders, the YAxis max value is set to 500 with step increments of 100. The problem is further exasperated when retrieving larger numbers such as getting the monthly logon count totals versus the daily. In this case the total count of a stacked column is no more than 13,000 to 14,000. When the chart renders in this case, the YAxis max value is set to 500,000 with step increments of 100,000. As you can imagine, at this point the stacked columns are nearly visible they are so small.
If I remove the stacked property and instead let the chart render each series as individual columns, the chart renders perfectly fine with a proper YAxis max value and step increment making an easy to read chart. However, there are times I need to use the stacked column approach as it lends more to the data I am trying to display. I cannot set a YAxis max value in the HTML because the data is based on the user's criteria for amount of time such as daily, weekly, monthly or yearly.
Lastly, one other issue I have seen not just in this chart but in all the charts is with the Tooltip DataFormatString. In the same markup below you will see I use a format of {0:N0} in order to show the comma placement in large numbers. This works perfectly fine for the YAxis labels, but the tooltip format will not change and will just show the number without the commas in them. I have another post where this is an issue with formatting the axis labels for date as well.
Thanks in advance,
Ron
I have been slowly replacing our RadChart controls with the new RadHtmlChart with small issues here and there as I have posted on the forums. I have come across a couple of additional issues while trying to replace some of our stacked bar charts.
Below is the HTML markup for the chart that I am trying to implement which is a column series with the property for stacked on the first series set to true as indicated by the documentation on how to create a stacked chart. However, the rendering of the chart does not produce the intended results. Although the columns do stack on one another, the YAxis max value is a much larger number than what it needs to be. This causes the bars to be small compared to the chart and hard to distinguish the stacks series. For instance, the data being returned in this case would not cause a stacked bar to have a total of more than about 90 to 100. When the chart renders, the YAxis max value is set to 500 with step increments of 100. The problem is further exasperated when retrieving larger numbers such as getting the monthly logon count totals versus the daily. In this case the total count of a stacked column is no more than 13,000 to 14,000. When the chart renders in this case, the YAxis max value is set to 500,000 with step increments of 100,000. As you can imagine, at this point the stacked columns are nearly visible they are so small.
If I remove the stacked property and instead let the chart render each series as individual columns, the chart renders perfectly fine with a proper YAxis max value and step increment making an easy to read chart. However, there are times I need to use the stacked column approach as it lends more to the data I am trying to display. I cannot set a YAxis max value in the HTML because the data is based on the user's criteria for amount of time such as daily, weekly, monthly or yearly.
Lastly, one other issue I have seen not just in this chart but in all the charts is with the Tooltip DataFormatString. In the same markup below you will see I use a format of {0:N0} in order to show the comma placement in large numbers. This works perfectly fine for the YAxis labels, but the tooltip format will not change and will just show the number without the commas in them. I have another post where this is an issue with formatting the axis labels for date as well.
<
telerik:RadHtmlChart
runat
=
"server"
ID
=
"MetricsDataChart"
Width
=
"660"
Height
=
"400"
Transitions
=
"true"
DataSourceID
=
"MetricsDataSource"
>
<
ChartTitle
Text
=
"Outlook Web Access Logon Traffic"
>
<
Appearance
Align
=
"Center"
Position
=
"Top"
/>
</
ChartTitle
>
<
Legend
>
<
Appearance
Visible
=
"true"
Position
=
"Top"
/>
</
Legend
>
<
PlotArea
>
<
XAxis
MajorTickType
=
"Outside"
MinorTickType
=
"None"
DataLabelsField
=
"Date"
>
<
LabelsAppearance
DataFormatString
=
"{0}"
RotationAngle
=
"75"
/>
<
TitleAppearance
Visible
=
"true"
Text
=
"Date"
/>
<
MinorGridLines
Visible
=
"false"
/>
</
XAxis
>
<
YAxis
MajorTickType
=
"Outside"
MinorTickType
=
"None"
>
<
LabelsAppearance
DataFormatString
=
"{0:N0}"
RotationAngle
=
"0"
/>
<
TitleAppearance
Visible
=
"true"
Text
=
"Logons"
/>
<
MinorGridLines
Visible
=
"false"
/>
</
YAxis
>
<
Series
>
<
telerik:ColumnSeries
Name
=
"Successful Logons"
DataField
=
"Success"
Stacked
=
"true"
>
<
LabelsAppearance
Visible
=
"false"
/>
<
TooltipsAppearance
DataFormatString
=
"{0:N0}"
/>
</
telerik:ColumnSeries
>
<
telerik:ColumnSeries
Name
=
"Failed Logons"
DataField
=
"Failure"
>
<
LabelsAppearance
Visible
=
"false"
/>
<
TooltipsAppearance
DataFormatString
=
"{0:N0}"
/>
</
telerik:ColumnSeries
>
</
Series
>
</
PlotArea
>
</
telerik:RadHtmlChart
>
Thanks in advance,
Ron