Varying % range in Chart

[tjstromquist]

I have a chart that is created from a pivot table. The chart shows Unit % change and Dollar % Change. The problem is when selecting a different product group sometimes the %'s are small -20 to 10% or 70 to 90%. Is there a way to set the chart to only show a smaller portion so that the column is readable? I need this smaller because this is part of a dashboard.

Thanks

 

[venkat1926]

try to manipulate the y axis scales.


rigt click y axis values and click format axis and choose "scale" and then experiment with minimum and maximum

venkat