Re: [libreoffice-users] Re: Scaling x-axis on chart

Budgie wrote:
> On 13/01/15 21:03, Andreas Säger wrote:
> > Am 13.01.2015 um 13:00 schrieb Budgie:
> > > Hi Tom,
> > > Thanks for the reply.  No joy so far.  The problem is expanding the x
> > > axis which is using dates.  It is set up for date format but I cannot
> > > find how to expand the scale.  I have a screen shot which illustrates my
> > > problem.  I shall try and attach it here.  If there is another procedure
> > > for sending data please let me know.
> > > Regards.
> >
> >
> > 1) menu:View>HighlightValues (Ctrl+F8
> > Are your dates and numbers highlighted in blue font now? If your dates
> > are black, then they are no dates at all.
> > 2) Chart type needs to be "x/y-scatter". Line charts have no numeric
> > x-axis. They treat all values as literal text
> Hi Andreas,
> Yes the dates and values in sheet are all in blue.
> I am using x/y-scatter type of chart.
> Could the problem be that the dates of the readings are not at regular
> intervals?  I have set the minimum and maximum for the x axis as
> 01/01/2009 and 31/12/2020 but whatever I do with the intervals the chart
> stays the same size.

The interval controls the interval between the tick marks along the axis 
(some or all of which are labelled, depending how close together they 
are). The ticks will always be at regular intervals, even if the points 
plotted on the graph are not. For dates it's not really possible to get 
the ticks at exact monthly intervals due to the differing number of days 
in each month. On one chart where I want them every 4 months, I have the 
interval set 121.75 (= 365.25 * 4 / 12). The day of month at each tick 
is not always the same (starting from 01/01/2009, the ticks are 
sometimes on the 1st, sometimes the 2nd and sometimes 3rd of the month) 
but it's good enough for my purpose.

(OT: How about crowd-funding a project to adjust the Earth's rotation 
and/or orbit such that a year divides sensibly into months and days? A 
few £gazillion ought to cover it? May also need to take out insurance 
against crashing the Earth into the Sun...)

Do you mean you want to make the whole chart wider?
1. Click on a cell outside of the chart, to ensure the chart is not 
selected.
2. Single-click on the chart.
3. There should be a small square at each corner and in the centre of 
each edge of the chart's frame. You can click and drag those to resize 
the frame, and the chart also scales with it.
4. Or, for more precise control of the size, right-click and select 
"Position and Size" from the context menu, or go to Format menu > 
Graphic > Position and Size.

If you want to change the size of the chart itself but not the frame 
surrounding it (e.g. to make expand the chart into empty space within 
the frame):
1. Double-click on the chart to start editing it.
2. Click on a blank area of the chart's background (i.e. within the area 
of the axes, but not actually on either of the axes or lines).
3. There should now be a small square at each corner and in the centre 
of each edge of the chart itself. You can click and drag those to resize 
the chart.
4. Or, for more precise control of the size, right-click and select 
"Position and Size" from the context menu, or go to Format menu > 
Position and Size.

Hope that helps.
Mark.


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted