Hello, I have a SQL Server Reporting Services (2008) chart (error chart). The X-axis has date intervals 1/1/2009, 2/1/2009, etc. The Y-axis has numeric intervals of 50. Values on the Y-axis are 0, 50 and 100. However, instead of displaying 0, 50 and 100 i would like to display "Small","Medium" and "Large" respectively. Does anyone know how this text replacement can be performed? Thank you Jason
A:
According to Arbitrary Label for Y axis in SSRS Charts, you can achieve the similar effect by using strip line collection. See How to: Highlight Chart Data by Adding Strip Lines.
eed3si9n
2009-06-19 05:00:45
Thank you so much - that was KILLING me. Can this be done for more than 3 labels (not that I need to do so)?
Jason Irwin
2009-06-22 21:55:03
No, the Excel format codes are pos;neg;zero. You can omit the zero for just pos;neg. If you need more than three, you will have to suppress the actual y-axis labeling and use a table control to simulate one (yes, it's rather fragile). This is slightly old but it will give you some ideas: http://msdn.microsoft.com/en-us/library/aa964128.aspx
Peter
2009-06-23 00:41:07
also, I haven't tried it myself, but I imagine ordinary textboxes might work, if the overlapping controls don't cause their own problems.
Peter
2009-06-23 00:44:03
You're welcome!
Peter
2009-06-23 00:52:17