title: Proper chart scaling in Reporting Services 2005
body: <p>I'm developing a simple bar-chart in Reporting Services 2005 with a stored procedure as data-source. The values in this graph can be both positive and negative, and can span a very big range, and hence I cannot specify any non-dynamic scale that will work for all scenarios.</p>
  
  <p>The problem I'm facing is that the automatic scaling pretty much sucks. I get no line to show where the zero-point is, and the y-scale labels are from top to bottom:</p>
  
  <p>8818</p>
  
  <p>-191181</p>
  
  <p>-391181</p>
  
  <p>etc etc...</p>
  
  <p>So my question is, what is the best approach to make the scale more adapted to human reading? Is there any guide out there? Does reporting services 2008 handle this better?</p>
  
  <p>Also, moving away from Reporting Services is not really an option. I realize how to put values and expression in the max, min, and the gridline interval fields, although its more of a question what expressions I should put there.</p>