I have a few issues with using charts (a stacked bar chart in this case) and telerik reporting. Note that we have the Q3 2011 version of the telerik reporting tools.
The first issue is getting the chart to use the correct "labels" for the x-axis.
I have some data which is similar to the following:
Store Department Category PercentA PercentB
APN A Start 2 3
APN A End 5 6
APN B Start 3 5
APN B End 6 9
HWT B Start 4 8
HWT B End 4 7
HWT C Start 2 3
HWT C End 8 8
I then use this data to generate a stacked bar chart. I use the Category department as the series, so each bar would be split into two (my actual chart has more than 2 categories, but that works fine). It would then plot PercentA and PercentB on the Y-axes - again no problems.
What I want to do is to use the Store + Department as the x-axis groups. I am able to use the Store + Department as a group for the tabular display of data, but not on the chart. The chart currently only creates 1 bar for each Store. Is there a way for me to tell the chart to use Store + Department for each bar?
For the second thing, the labels on the x-axis (store) is intersecting the x-axis itself - please see attached screenshot for what I meant. Is there a way to tell the chart to keep all x-axis labels under the x-axis line?
The first issue is getting the chart to use the correct "labels" for the x-axis.
I have some data which is similar to the following:
Store Department Category PercentA PercentB
APN A Start 2 3
APN A End 5 6
APN B Start 3 5
APN B End 6 9
HWT B Start 4 8
HWT B End 4 7
HWT C Start 2 3
HWT C End 8 8
I then use this data to generate a stacked bar chart. I use the Category department as the series, so each bar would be split into two (my actual chart has more than 2 categories, but that works fine). It would then plot PercentA and PercentB on the Y-axes - again no problems.
What I want to do is to use the Store + Department as the x-axis groups. I am able to use the Store + Department as a group for the tabular display of data, but not on the chart. The chart currently only creates 1 bar for each Store. Is there a way for me to tell the chart to use Store + Department for each bar?
For the second thing, the labels on the x-axis (store) is intersecting the x-axis itself - please see attached screenshot for what I meant. Is there a way to tell the chart to keep all x-axis labels under the x-axis line?
2 Answers, 1 is accepted
0
Rem
Top achievements
Rank 1
Rank 1
answered on 30 Nov 2011, 03:55 AM
Ignore the first problem - I have been able to get it to work using CalculatedFields on the data source.
Now I just need the second problem sorted out. Thanks :)
Now I just need the second problem sorted out. Thanks :)
0
Hi Rem,
Elian
the Telerik team
From the chart properties -> PlotArea -> XAxis -> Appearance -> LabelAppearance -> Dimensions you can set absolute dimensions and some margins that will fit your empty spaces.
All the best,Elian
the Telerik team
Q3’11 of Telerik Reporting is available for download. Register for the What's New in Data Tools webinar to see what's new and get a chance to WIN A FREE LICENSE!