Maximum 200 categories for x axis?

5 posts, 1 answers
  1. Jeremy
    Jeremy avatar
    96 posts
    Member since:
    Mar 2010

    Posted 21 May 2010 Link to this post

    Hi

    I've just been experimenting with charting random data from the Adventureworks database and running into problems displaying a 2D Bar chart with over 1000 categories. It seems to hit a hard limit of 200. Selecting just the top 200 categories (or more) the Y-axis labels are not loaded and neither are the data points, at the top 199 (or less) everything appears as expected.

    While I agree this is a very good idea, as the chart looks way too crowded, I need to know if this is a hardcoded limit as our implementation of the Telerik charts allows users to run their own SQL queries - which means they could try running anything not even vaguely suited to charting. Also, Is it the same for all chart types?

    This is the SQL I am using to generate excessive categories:
    Select c.FirstName, Count(c.FirstName) As names
    From AdventureWorks.Person.Contact c
    Group By c.FirstName

    Kind Regards,
    Jeremy
  2. Ves
    Admin
    Ves avatar
    2879 posts

    Posted 26 May 2010 Link to this post

    Hi Jeremy Camplin,

    Actually, this limitation has been removed. You can download the latest internal build from your account and give it a try -- you should not experience such issues. As for the crowded X axis -- RadChart offers some features, dedicated to solving such problems:
    • LabelStep -- the chart will skip some of the labels along the X axis. Well, this does not seem to suit well for categories, as each and every one is meaningful and unique.
    • StepLabel -- controlled by the StepLabelLevelCount and StepLabelLevelHeight. This will arrange the X axis item labels at several levels
    • RotationAngle -- the labels will be rotated to avoid overlapping.

    Best regards,
    Ves
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  3. DevCraft banner
  4. Jeremy
    Jeremy avatar
    96 posts
    Member since:
    Mar 2010

    Posted 12 Aug 2010 Link to this post

    Hi

    Do I just replace the dlls in my bin folder with the ones from the internal build download? I tried 00730RadControls_for_Silverlight_3_2010_2_0806_DEV and no change. When will this limitation be removed in the production version?

    Kind Regards,
    Jeremy
  5. Answer
    Ves
    Admin
    Ves avatar
    2879 posts

    Posted 16 Aug 2010 Link to this post

    Hello Jeremy,

    It seems I have not provided an important piece of information here -- by default RadChart groups several datapoints into one item, where there are lots of points in the chart. You can find more details in this help topic. When grouping items in this manner, the information for the categories cannot be preserved, so the chart simply shows numbers. However, this can be disabled by setting the RadChart1.SamplingSettings.SamplingThreshold property to 0. This will allow the chart to display all the points with their categories.

    Upgrading - simply copying the binaries to the Bin folder would not be enough. You need to store them in a safe place (usually this is the installation folder) and update the project references to point to the new assemblies.

    Best regards,
    Ves
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  6. Jeremy
    Jeremy avatar
    96 posts
    Member since:
    Mar 2010

    Posted 18 Aug 2010 Link to this post

    Changing the sampling settings works. Thanks!
Back to Top
DevCraft banner