Monthly Axis Label, Weekly Data

Thread is closed for posting
4 posts, 0 answers
  1. David
    David avatar
    10 posts
    Member since:
    Sep 2010

    Posted 02 Feb 2011 Link to this post

    Hi,
       I would like to create a bar chart with the x-axis labels displaying Jan to Dec, but with the bar data being shown weekly.  Basically, I want 52 data points along the x-axis, but only 12 labels.  Is there an easy way to format this so that the labels are evenly spaced based on "12", not on some fraction of 52?

    Thanks
    Dave

  2. Vladimir Milev
    Admin
    Vladimir Milev avatar
    1061 posts

    Posted 07 Feb 2011 Link to this post

    Hi David,

    There are several ways such a chart could look like. Can you please send us a sample picture showing how you envision your graph so that we could better help you?

    Best wishes,
    Vladimir Milev
    the Telerik team
    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
  3. David
    David avatar
    10 posts
    Member since:
    Sep 2010

    Posted 08 Feb 2011 Link to this post

    Hello Vladimir,
       Per the attached picture, I have a bar chart showing weekly pay (and payroll deductions) for a year, and other similar situations.  This is for illustrative purposes of employee / student financial training, and the exact dates are not important, just the progression through the year.  We would like to show the x-axis just as month name abbreviations, but where 12 doesn't go into 52 evenly I can't just show every 4th label (can I?), for example.   Would like the X-axis labels to look like | Jan | Feb | Mar | Apr... |, evenly spaced along it, but still have the 52 stacked bars spread out also. 

    Thanks
    Dave
  4. Vladimir Milev
    Admin
    Vladimir Milev avatar
    1061 posts

    Posted 11 Feb 2011 Link to this post

    Hi David,

    Unfortunately, there is not a good way to do this out of the box. The XAxis does not understand DateTime and it cannot determine which weeks map into which months to perform the desired operation correctly.

    You can iterate over the axis items and assign label text manually by observing which week a month starts and ends.

    We sincerely apologize for this inconvenience.

    Best wishes,
    Vladimir Milev
    the Telerik team
    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
Back to Top