Static Data Item Labels

[Philip Senechal]

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!

[Schlurk]

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.

[Philip Senechal]

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!

[Philip Senechal]

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.