Thank you to those who replied. I found that changing the format of the
cell data did not affect the chart format, the cells were already
formatted as Date. The fix is to use an XY rather than a Line chart.
Regards,
Chuck
At 11:06 29/12/2012 -0800, you wrote:
I do have the date column formatted as Date.
The first thing to check is probably that this is actually true. If
you formatted the column as Date but then entered data that Calc did
not recognise as dates in your locale, you may actually have text
entries there. The easiest way to test this is (temporarily) to
change the date format to another date format: does that actually
change the display? If the date format is operative it will; if the
entries are actually text which looks like dates, it will not.
How can I get the chart to be intelligently formatted such that
missing data points for dates are given appropriate space?
The rest of the answer probably depends crucially on exactly which
chart type you have chosen, so you will have to give more details.
I trust this helps.
What kind of chart do you use? The best for not equidistant x-values
is an XY-chart.
--
For unsubscribe instructions 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
