Is there any way to use expressions or whatever to automatically scale the Y-axis of a chart depending on the data. It looks like everything is hard coded in reporting services especially the chart and you would hard code the max and min values at certain range. This is ridiculous! Is there any way that I can set the max and min values depending on the data, so that when a chart goes up to 600% it doesn't have to show 1000% or when there is no minus (-) numbers, it doesn't have to show -500% in the chart. Can I use expression the max and min windows or is the chart smart enough to bring a decent chart depending on the data without any hardcoded limits, settings, intervals, etc.? This is ridiculous. Any help is appreciated. Thanks, Enkh.

Just leave the min/max settings blank and the axis will autoscale. Furthermore, in RS 2005 you can use expressions to dynamically calculate min/max/etc. axis settings. -- Robert

It's not automatically scaling to the right size. For example what I'm seeing is that the max chart is 600%, but the chart is setting the max to 1000% that is too much. Plus the chart is calculation between columns. Enkh.

I guess it would help if you could post a simple report example (e.g. based on Northwind data or AdventureWorks data) that demonstrates the issue you are experiencing. -- Robert

to base your chart off of your data you can do two things: 1. leave entries blank and let SSRS auto calculate 2. in the min you can enter a SSRS formula: =Min(<datafield>) - and do the same for the max You may need to clear the rdl.data to see the new results.