Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index

At 13:50 17/02/2016 -0800, Joel Madero wrote:
Pedro Pedlino wrote:
(BTW if you make the first date value 1/15/2007 and the second 2/15/2007 you can simply drag the X values all the way down and LO is smart enough to always use the 15th of every month)

I had this kind of a setup before and it just bothered me that it wasn't entirely accurate. My data is not pertaining to a particular day, it's a summary of the months so having the data show the 15th of the month was just annoying me

This shouldn't be a problem. In order for the chart to make sense, the date values need to be exactly that - not merely pieces of text that look like dates. If one month was missing from your data, you would want the remaining values to be spaced properly - and this would happen only with true dates, not with text values.

But there is no need for the day numbers (whatever they are) to show in the chart: the dates can be formatted as you wish. In my example chart, I've chosen "MMM YYYY" as the date format, which shows any day in this month as "Feb 2016". You can arrange chart axis formatting in either of two ways: either inherited from the formatting in the data ranges or set in the chart specification itself.

I trust this helps.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.