Gianfranco
Top achievements
Rank 1
Rank 1
Gianfranco
asked on 17 Apr 2013, 10:28 AM
Hi all,
I am new to Telerik Reporting, and I have to make the chart shown in Picture1. For now, I have achieved the result shown in Picture2.
Ideally, the resulting chart should be exactly identical to Picture1, but for now the main goal is adding the labels "CEO", "CFO", etc. above the bars, and the numbers in the yellow circles.
I have no idea on how to do this; can anyone point me in the right direction?
Thanks in advance,
Gianfranco
I am new to Telerik Reporting, and I have to make the chart shown in Picture1. For now, I have achieved the result shown in Picture2.
Ideally, the resulting chart should be exactly identical to Picture1, but for now the main goal is adding the labels "CEO", "CFO", etc. above the bars, and the numbers in the yellow circles.
I have no idea on how to do this; can anyone point me in the right direction?
Thanks in advance,
Gianfranco
1 Answer, 1 is accepted
0
Hi Gianfranco,
We have reviewed your chart and we can advise you to use the new Graph item since it is simpler and has much more functionality compared to the old chart.
To achieve the grouping effect you will have to add a simple column graph using the wizard with category set to position (like CFO, CEO, etc.). Select the value to be your value without aggregate. Then when the graph is produced select it and under CategoryGroups select your group and add another grouping, this time by name. Do not remove the default sorting (and optionally you can add a second sorting for the Names as well).
Regarding the little circles in each bar - create a line series using the exact same data as the bar series. Then set the Y value of the line series to be constant and also a number that will place the line lower in your graph. Then set the DataPointStyle to be Visible = true. Then set the size of the series to be a random number and set the minimum and maximum size of the marker to be equal, for example 20px. Select the marker type to be circle. Hide the lines between the circles. Finally set the DataPointLabelStyle to be Visible = true and set the label value to be the field that holds your value.
Since we saw that other things will be needed in your Graph as well here are some tips: for the threshold create new line series, style it appropriately and set the Y value to be constant (equal to 3). For the red markers you can use range bar instead and hide it conditionally. Finally you can use conditional formatting for the yellow values of the bar series.
I hope that helps.
Kind regards,
IvanY
the Telerik team
We have reviewed your chart and we can advise you to use the new Graph item since it is simpler and has much more functionality compared to the old chart.
To achieve the grouping effect you will have to add a simple column graph using the wizard with category set to position (like CFO, CEO, etc.). Select the value to be your value without aggregate. Then when the graph is produced select it and under CategoryGroups select your group and add another grouping, this time by name. Do not remove the default sorting (and optionally you can add a second sorting for the Names as well).
Regarding the little circles in each bar - create a line series using the exact same data as the bar series. Then set the Y value of the line series to be constant and also a number that will place the line lower in your graph. Then set the DataPointStyle to be Visible = true. Then set the size of the series to be a random number and set the minimum and maximum size of the marker to be equal, for example 20px. Select the marker type to be circle. Hide the lines between the circles. Finally set the DataPointLabelStyle to be Visible = true and set the label value to be the field that holds your value.
Since we saw that other things will be needed in your Graph as well here are some tips: for the threshold create new line series, style it appropriately and set the Y value to be constant (equal to 3). For the red markers you can use range bar instead and hide it conditionally. Finally you can use conditional formatting for the yellow values of the bar series.
I hope that helps.
Kind regards,
IvanY
the Telerik team
Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.