title: SSRS 2008: how to change chart axis unit dynamically?
body: <p>I have a chart in SSRS report and its Y-Axis shows total revenue from salesman. The unit for Y-Axis is "Million" and it works perfect for total amount.   </p>
  
  <p>However, there are about thousands of salesman and when one particular salesman is selected in parameter panel, his/her sales amount may only be at "hundred" level. Thus, the bar on chart would be too small to identify. </p>
  
  <p>Is there any way to change Y-Axis Unit dynamically during the running time? </p>