Static Data Item Labels

Thread is closed for posting
4 posts, 0 answers
  1. Philip Senechal
    Philip Senechal avatar
    152 posts
    Member since:
    Apr 2008

    Posted 09 Feb 2010 Link to this post

    I have a vertical bar chart that's bound to a data table that has only 1 row with 7 columns. I've created the bar chart with 7 series so that each vertical bar represents one column of the data. I currently have a data label at the top of each bar that shows the value. I would like to add a static label at the bottom of each bar to identify what that bar represents. For example, the first bar represents requests that were open for 0-15 days. I would like the label under the bar on the x-axis to read "0-15". The value on the y-axis is how many requests fell into that category.

    Can I do it with the way my data is coming back, or do I need to modify my SQL so that I end up with multiple rows? Thanks!
  2. Schlurk
    Schlurk avatar
    812 posts
    Member since:
    May 2009

    Posted 10 Feb 2010 Link to this post

    You could always follow the ideas in the "How do I add Axis Labels Programmatically" documentation article to set the x-axis labels of each item in the series.
  3. Philip Senechal
    Philip Senechal avatar
    152 posts
    Member since:
    Apr 2008

    Posted 10 Feb 2010 Link to this post

    Thanks! That actually works great, just not the way I have my query designed. I think I just need to redesign the query so that each group value is in it's own row. But I still might use the code from that example you sent me, so thanks a bunch!
  4. Philip Senechal
    Philip Senechal avatar
    152 posts
    Member since:
    Apr 2008

    Posted 10 Feb 2010 Link to this post

    After some testing, yes this would work if each data item is in it's own row, but then I lose the ability to include zero values which I need to have. I'll keep playing.
Back to Top