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

Date as X-Axis on a bar chart

4 Answers 293 Views
Chart (obsolete as of Q1 2013)
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
erwin
Top achievements
Rank 1
Veteran
erwin asked on 13 Oct 2008, 06:01 PM
Hi,

I'd like to draw a bar chart, where the X Axis are Days and the Y Axis are values for that Day. X-Axis Step is 1 Day.

The chart draws fine when I calculate a decimal age in days as X-Axis, however, I would like the actual dates to appear as labels on the X-Axis, rotated 90 degrees.

What's the best way to do this?

Thanks and regards
erwin

4 Answers, 1 is accepted

Sort by
0
Accepted
Dwight
Telerik team
answered on 17 Oct 2008, 04:55 AM
Hello Erwin,

Here is a sample code changing the the XAxis labels appearance and format:
this.radChart1.PlotArea.XAxis.IsZeroBased = false
this.radChart1.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = 90; 
this.radChart1.PlotArea.XAxis.Appearance.LabelAppearance.Position.AlignedPosition = Telerik.Charting.Styles.AlignedPositions.Top; 
this.radChart1.PlotArea.XAxis.Appearance.ValueFormat = Telerik.Charting.Styles.ChartValueFormat.ShortDate; 

If you have further questions do not hesitate to ask.

Regards,
Evtim
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
erwin
Top achievements
Rank 1
Veteran
answered on 20 Oct 2008, 01:19 PM
Thanks, works like a charm!
what I overlooked was ZeroBased property.

regards
erwin
0
Ambu
Top achievements
Rank 1
answered on 26 Feb 2009, 04:07 PM

I am trying to add dates to my x-axis as well, but only generic dates are being returned. These fixes do not work for me. Am I missing something?

Here is my dataset:
CountryName    LastUpdate                         Sites   Running Total
United States    2009-02-02 00:00:00.000   4         4
United States    2009-02-19 00:00:00.000   1         5

More Details
1. The date is returned as the datetime datatype.
2. AutoScale and IsZeroBased values for the X-Axis are set to false
3. My code is included below.

 
        <telerik:RadChart ID="RadChart1" runat="server" AutoLayout="True" DataGroupColumn="CountryName" 
            DataSourceID="SqlDataSource1" DefaultType="Line" Height="400px">  
            <Series> 
                <telerik:ChartSeries DataYColumn="RunningTotal" Name="United States" Type="Line">  
                    <Appearance> 
                        <FillStyle MainColor="213, 247, 255">  
                        </FillStyle> 
                    </Appearance> 
                </telerik:ChartSeries> 
            </Series> 
            <PlotArea> 
                <XAxis AutoScale="False" DataLabelsColumn="LastUpdate" IsZeroBased="False" MaxValue="2" 
                    MinValue="1" Step="1">  
                    <Appearance ValueFormat="ShortDate">  
                        <LabelAppearance Position-AlignedPosition="Top" RotationAngle="45">  
                        </LabelAppearance> 
                    </Appearance> 
                    <AxisLabel Visible="True">  
                        <Appearance Visible="True">  
                        </Appearance> 
                        <TextBlock Text="Timeline">  
                        </TextBlock> 
                    </AxisLabel> 
                    <Items> 
                        <telerik:ChartAxisItem Value="1">  
                        </telerik:ChartAxisItem> 
                        <telerik:ChartAxisItem Value="2">  
                        </telerik:ChartAxisItem> 
                    </Items> 
                </XAxis> 
                <YAxis> 
                    <AxisLabel Visible="True">  
                        <Appearance Visible="True">  
                        </Appearance> 
                        <TextBlock Text="Number of Sites">  
                        </TextBlock> 
                    </AxisLabel> 
                </YAxis> 
            </PlotArea> 
            <ChartTitle> 
                <TextBlock Text="Site Completion Summary">  
                </TextBlock> 
            </ChartTitle> 
        </telerik:RadChart> 
Select a.CountryName, Convert(datetime, a.LastUpdate, 101) as LastUpdate,  
       a.Sites,  
       SUM(b.Sites) AS RunningTotal  
From   
(  
    Select DATEADD(dd, 0, DATEDIFF(dd, 0, atss.LastUpdate)) as LastUpdate, c.CountryName,  
           Max(DATEADD(dd, 0, DATEDIFF(dd, 0, atss.LastUpdate))) as LastUpdateMax,  
           Count(ts.TrackedSiteID) as Sites  
    From SLLS_TrackedSite ts  
    Left Outer Join SLLS_AuditTrackSiteStatus atss On atss.TrackedSiteID = ts.TrackedSiteID  
    Left Outer Join SLLS_Country c On c.CountryID = ts.CountryID  
    Where ts.SiteStatusID = 1 And 
          atss.SiteStatusID = 1 And 
          ts.CountryID = 1  
    Group By DATEADD(dd, 0, DATEDIFF(dd, 0, atss.LastUpdate)), c.CountryName  
) a  
Cross Join 
(  
    Select DATEADD(dd, 0, DATEDIFF(dd, 0, atss.LastUpdate)) as LastUpdate, c.CountryName,  
           Max(DATEADD(dd, 0, DATEDIFF(dd, 0, atss.LastUpdate))) as LastUpdateMax,  
           Count(ts.TrackedSiteID) as Sites  
    From SLLS_TrackedSite ts  
    Left Outer Join SLLS_AuditTrackSiteStatus atss On atss.TrackedSiteID = ts.TrackedSiteID  
    Left Outer Join SLLS_Country c On c.CountryID = ts.CountryID  
    Where ts.SiteStatusID = 1 And 
          atss.SiteStatusID = 1 And 
          ts.CountryID = 1  
    Group By DATEADD(dd, 0, DATEDIFF(dd, 0, atss.LastUpdate)), c.CountryName  
) b  
WHERE (b.LastUpdate <= a.LastUpdate)  
GROUP BY a.CountryName,a.LastUpdate,a.Sites  
ORDER BY a.CountryName,a.LastUpdate,a.Sites 

0
Dwight
Telerik team
answered on 27 Feb 2009, 08:05 AM
Hello Allan,

Please, find the answer to your question in the other thread:
http://www.telerik.com/community/forums/winforms/chart/date-on-x-axis-on-line-chart.aspx

Also, note, that the ASP.NET chart has separate resources and support area:
http://www.telerik.com/products/aspnet-ajax/chart.aspx

Best wishes,
Evtim
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Tags
Chart (obsolete as of Q1 2013)
Asked by
erwin
Top achievements
Rank 1
Veteran
Answers by
Dwight
Telerik team
erwin
Top achievements
Rank 1
Veteran
Ambu
Top achievements
Rank 1
Share this question
or