how to ensure that the y-axis range begins with 0?

I have several charts in a report. The problem is the y-axis does not always begin with 0, so it makes it hard to compare the data between charts. Is there a way to ensure that the displayed y-axis range begins with 0?

TIA.

Find more posts tagged with

Comments

cantyman

Perhaps a better way to ask the question:

Can we control the scale of the y-axis? My goal is to configure the scale from 0 to max data value in result set. Is this possible?

Thanks in advance for any help on this.

Pipi

<blockquote class='ipsBlockquote' data-author="cantyman">Perhaps a better way to ask the question: 
 
Can we control the scale of the y-axis? My goal is to configure the scale from 0 to max data value in result set. Is this possible? 
 
Thanks in advance for any help on this.</blockquote>
 
 
You can write a script to set the y axis scale's start value 
Scale.setMin();

cypherdj

Yes, you can control the origin of the y-axis. Edit your chart, go to the Format Chart tab, select Chart Area -> Axis -> Y-Axis.

In the origin dropdown, select "value" and enter 0 in the value.

That should do it without using a script.

Hope that helps,
Cedric

cantyman

Thanks cedric and pipi, it worked! I used cedric's suggestion (seemed easiest at the time).