You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Brian Barker <b....@btinternet.com> on 2016/09/21 00:28:24 UTC
Re: Adjustment of high limit and low Limit in AOO-Calc Line
Chart
At 15:31 20/09/2016 -0400, Vince Bonly wrote:
>I am working with a line graph chart in Calc that presently shows
>"180.00" as the top limit and "0.00" as the low limit. I vaguely
>recall that there is a way to adjust those limits, but I have not
>been able to locate the edit-dialog. I want high limit to be "250"
>and low limit to be "100" and increments of 5.
You are talking about the y-axis, I trust - not the x-axis?
o Double-click the chart, so that it shows its grey border (not the
eight coloured handles).
o Right-click the y-axis and go to Format Axis... (or go to Format |
Axis > | y-axis...).
o On the Scale tab, remove the ticks from Automatic as necessary and
modify the Minimum, Maximum, and "Major interval" values.
Note that the labels will follow the grid you have defined only if
their font size is small enough to permit this. You can adjust this
on the Font tab of the same dialogue.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Adjustment of high limit and low Limit in AOO-Calc Line
Chart
Posted by Brian Barker <b....@btinternet.com>.
At 09:14 21/09/2016 -0400, Vince Bonly wrote:
>Thank you, Brian.
No probs!
>I hope you have a successful trip.
Trip? What trip? Do you know something I don't?!
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Adjustment of high limit and low Limit in AOO-Calc Line Chart
Posted by Vince <wa...@verizon.net>.
It's possible that I do!
However, my apology; I mixed up you for another poster (Rory).
On 9/21/2016 11:39 AM, Brian Barker wrote:
> At 09:14 21/09/2016 -0400, Vince Bonly wrote:
>> Thank you, Brian.
>
> No probs!
>
>> I hope you have a successful trip.
>
> Trip? What trip? Do you know something I don't?!
>
> Brian Barker
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Adjustment of high limit and low Limit in AOO-Calc Line Chart
Posted by "Vince B." <wa...@verizon.net>.
Thank you, Brian. As is the usual case, your concise hints are extremely helpful. Yes, my issue was in regard to the Y-axis scaling.
I hope you have a successful trip.
Regards,
Vince
Sent from my iPad
> On Sep 20, 2016, at 20:28, Brian Barker <b....@btinternet.com> wrote:
>
> At 15:31 20/09/2016 -0400, Vince Bonly wrote:
>> I am working with a line graph chart in Calc that presently shows "180.00" as the top limit and "0.00" as the low limit. I vaguely recall that there is a way to adjust those limits, but I have not been able to locate the edit-dialog. I want high limit to be "250" and low limit to be "100" and increments of 5.
>
> You are talking about the y-axis, I trust - not the x-axis?
>
> o Double-click the chart, so that it shows its grey border (not the eight coloured handles).
> o Right-click the y-axis and go to Format Axis... (or go to Format | Axis > | y-axis...).
> o On the Scale tab, remove the ticks from Automatic as necessary and modify the Minimum, Maximum, and "Major interval" values.
>
> Note that the labels will follow the grid you have defined only if their font size is small enough to permit this. You can adjust this on the Font tab of the same dialogue.
>
> I trust this helps.
>
> Brian Barker
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>