Change the scale of the chart in Report Builder

Hi,

I have an stacked chart with line with markers. The scale on the right side is the finished good which has a min qty of 383 while the highest is 52439. how can i set this scale that start from 0 to 300 and soon. right now under scale properties I set the max to 60000, the min is set to auto while in the interval properties i set this to 10000. anybody help or suggestion on how this line marker adjust the scale quantity (fisnished good). thank you. 

September 10th, 2015 10:23pm

Hi Lenoj, 

According to your description, you want adjust the right scale, right? 

In Reporting Services, a scale break is a stripe drawn across the plotting area of a chart to denote a break in continuity between the high and low values on a value axis (usually the vertical, or y-axis). In your scenario, since you mentioned that the values are from 383 to 52439, so you can enable scale breaks for the vertical axis. Please refer to the following steps: 

Right-click the vertical axis and enable scale breaks. 

The result is like below: 

Reference: 

Add Scale Breaks to a Chart (Report Builder and SSRS)

If you have any other question, please feel free to ask. 

Regards,
Shrek Li

Free Windows Admin Tool Kit Click here and download it now
September 13th, 2015 11:18pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics