The stored procedure returns fields i.e. field1, field2, etc... field1 has figures in percentages such as: 3.65, -1.22, 1.3, etc... field2 has the dates. On the horizontal axis line, the dates are shown correctly. On the vertical axis of the chart, it shows the percentage figues. These percentage figures have +ve and -ve values and there is 0 in the middle of the vertical axis. All working fine... Questions 1- How do I show the percentage % sign next to these numbers on the vertical axis? 2- How can I move the labels of the dates to the centre of the chart where it crosses the horizontal 0 line ? Thankyou
As you got plenty of queries in AXIS formatting I would recommend the book http://www.wrox.com/WileyCDA/Section/SQL-Server-Reporting-Services-Chart-Reports.id-291636.html and http://www.amazon.com/Professional-Server-2005-Reporting-Services/dp/0764584979 and article in this case.