i have rad chart with the following sql datasource
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Cnn_StatisticsSql %>"
SelectCommand="SELECT COUNT(Title) AS Title_Count,
Title AS Account_Type,
LEFT(BankingDate, 7) AS Date
FROM Extracted.Sepordeh_EftetahShodeh
WHERE LEFT(BankingDate, 4) IN ( '1388' )
GROUP BY Title , LEFT(BankingDate, 7) ORDER BY 3 "></asp:SqlDataSource>
<telerik:RadChart ID="RadChart1" runat="server" AutoLayout="True" AutoTextWrap="True"
IntelligentLabelsEnabled="True" Width="945px" Height="285px" Skin="DeepBlue"
DataGroupColumn="Account_Type" DataSourceID="SqlDataSource1">
<Appearance>
<FillStyle FillType="ComplexGradient">
<FillSettings>
<ComplexGradient>
<telerik:GradientElement Color="26, 120, 179" />
<telerik:GradientElement Color="35, 189, 254" Position="0.5" />
<telerik:GradientElement Color="26, 120, 179" Position="1" />
</ComplexGradient>
</FillSettings>
</FillStyle>
<Border Color="0, 66, 110" Width="5" />
</Appearance>
<Series>
</Series>
<Legend Visible="False">
<Appearance Dimensions-Margins="1px, 2%, 12%, 1px" Visible="False">
<ItemTextAppearance TextProperties-Color="White">
</ItemTextAppearance>
<FillStyle GammaCorrection="False" MainColor="37, 255, 255, 255">
</FillStyle>
<Border Color="76, 255, 255, 255" />
</Appearance>
<TextBlock>
<Appearance Position-AlignedPosition="Top" TextProperties-Color="LightSkyBlue">
</Appearance>
</TextBlock>
</Legend>
<PlotArea>
<DataTable>
<Appearance Position-Auto="False" Position-X="0" Position-Y="0">
</Appearance>
</DataTable>
<EmptySeriesMessage Visible="True">
<Appearance Visible="True">
</Appearance>
</EmptySeriesMessage>
<XAxis AutoScale="False" DataLabelsColumn="Date" MaxValue="7" MinValue="1"
Step="1">
<Appearance Color="98, 183, 226" MajorTick-Color="98, 183, 226">
<MajorGridLines Color="98, 183, 226" Width="0" />
<TextAppearance TextProperties-Color="White">
</TextAppearance>
</Appearance>
<AxisLabel>
<Appearance Dimensions-Paddings="1px, 1px, 10%, 1px">
</Appearance>
<TextBlock>
<Appearance TextProperties-Color="LightSkyBlue">
</Appearance>
</TextBlock>
</AxisLabel>
</XAxis>
<YAxis>
<Appearance Color="98, 183, 226" MajorTick-Color="98, 183, 226"
MinorTick-Color="98, 183, 226">
<MajorGridLines Color="120, 209, 248" />
<MinorGridLines Color="120, 209, 248" Width="0" />
<TextAppearance TextProperties-Color="White">
</TextAppearance>
</Appearance>
<AxisLabel>
<TextBlock>
<Appearance TextProperties-Color="LightSkyBlue">
</Appearance>
</TextBlock>
</AxisLabel>
</YAxis>
<Appearance Dimensions-Margins="19%, 90px, 12%, 9%">
<FillStyle MainColor="50, 255, 255, 255" SecondColor="Transparent">
</FillStyle>
<Border Color="97, 180, 223" />
</Appearance>
</PlotArea>
<ChartTitle>
<Appearance Dimensions-Margins="4%, 10px, 14px, 6%">
<FillStyle MainColor="">
</FillStyle>
</Appearance>
<TextBlock>
<Appearance TextProperties-Color="White" TextProperties-Font="Verdana, 14pt">
</Appearance>
</TextBlock>
</ChartTitle>
</telerik:RadChart>
I have sorted the chart by date. the problem is when there is no data for a specific date the bar chart is not left empty but it is filled with the next available data that belongs to the following dates.