This is a migrated thread and some comments may be shown as answers.

[Solved] Grouped data in BarSeries

4 Answers 122 Views

Chart (HTML5)

This is a migrated thread and some comments may be shown as answers.

Francois asked on 25 Apr 2014, 01:18 PM

barseries_example.png

excel_example.png

Hello Telerik,

Currently I'm implementing a HtmlChart in asp.net. I'm translating a couple of excel sheets into asp.net.
please find attached two files. one of the excel example. one of the current barseries i've made up so far.

my question is: how can I bind grouped data? i want the Y axis to be displayed by year, and then by month. Now only the month is displayed.
could you assist me in defining the correct barseries?

<div class="LeftMonitorDiv">

<telerik:RadPivotGrid ID="CAK_A1_PivotGrid" runat="server"

AggregatesLevel="0" AllowPaging="True" Culture="nl-NL"

DataSourceID="CAK_A1_UniekeClienten_Datasource"

UseQueryableDataProvider="True"

ExportSettings-FileName="CAK_A1_UniekeClienten"

ExportSettings-IgnorePaging="True" ExportSettings-OpenInNewWindow="True"

Skin="Metro" PageSize="20" AllowFiltering="False" TotalsSettings-RowsSubTotalsPosition="None"

TotalsSettings-ColumnsSubTotalsPosition="None" TotalsSettings-RowGrandTotalsPosition="None" TotalsSettings-ColumnGrandTotalsPosition="None"

ShowDataHeaderZone="false" ShowFilterHeaderZone="false" ShowColumnHeaderZone="false" GroupTotalsVisibility="None">

<PagerStyle ChangePageSizeButtonToolTip="Change Page Size" PageSizeControlType="RadComboBox"></PagerStyle>

<Fields>

<telerik:PivotGridRowField DataField="Jaar" UniqueName="JaarColumn" Caption="Jaar">

</telerik:PivotGridRowField>

<telerik:PivotGridRowField DataField="Periode" UniqueName="PeriodeColumn" Caption="Periode">

</telerik:PivotGridRowField>

<telerik:PivotGridRowField DataField="ClientenUniek" UniqueName="ClientenUniek" Caption="Unieke Clienten">

</telerik:PivotGridRowField>

</Fields>

<ClientSettings EnableFieldsDragDrop="false">

</ClientSettings>

<ExportSettings OpenInNewWindow="True" FileName="CAK_A1_UniekeClienten" IgnorePaging="True" />

</telerik:RadPivotGrid>

</div>

<div class="RightMonitorDiv">

<telerik:RadHtmlChart runat="server" Height="338px" Width="563px" Skin="Metro" CssClass="CIZJeugdVervoerPieChart"

ID="CAK_A1_UniekeClienten_PieChart" Transitions="true" DataSourceID="CAK_A1_UniekeClienten_Datasource">

<Appearance>

<FillStyle BackgroundColor="White"></FillStyle>

</Appearance>

<ChartTitle Text="Unieke cliënten per periode">

<Appearance Align="Center" BackgroundColor="White" Position="Top" Visible="True">

</Appearance>

</ChartTitle>

<Legend>

<Appearance BackgroundColor="White" Position="Bottom" Visible="true">

</Appearance>

</Legend>

<PlotArea>

<Appearance>

<FillStyle BackgroundColor="White"></FillStyle>

</Appearance>

<Series>

<telerik:BarSeries Name="Periode" Stacked="false" DataFieldY="ClientenUniek">

<Appearance>

<FillStyle BackgroundColor="Red" />

</Appearance>

<TooltipsAppearance BackgroundColor="White" DataFormatString="${0}" />

<LabelsAppearance Position="Center" DataField="Periode"/>

</telerik:BarSeries>

</Series>

<XAxis DataLabelsField="Periode">

</XAxis>

<YAxis>

<LabelsAppearance DataFormatString="{0}" />

</YAxis>

</PlotArea>

</telerik:RadHtmlChart>

</div>

4 Answers, 1 is accepted

Accepted