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.
--
To unsubscribe e-mail to: [email protected]
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