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

Monthly Axis Label, Weekly Data

3 Answers 64 Views
Chart (Obsolete)
This is a migrated thread and some comments may be shown as answers.
David
Top achievements
Rank 1
David asked on 02 Feb 2011, 05:40 PM
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

3 Answers, 1 is accepted

Sort by
0
Vladimir Milev
Telerik team
answered on 07 Feb 2011, 06:36 PM
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.
0
David
Top achievements
Rank 1
answered on 08 Feb 2011, 11:10 PM
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
0
Vladimir Milev
Telerik team
answered on 11 Feb 2011, 04:33 PM
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.
Tags
Chart (Obsolete)
Asked by
David
Top achievements
Rank 1
Answers by
Vladimir Milev
Telerik team
David
Top achievements
Rank 1
Share this question
or