Calc dates wrong?

TaurusOoo · General User Joined: 23 Feb 2012 Posts: 5

Here is the problem, I'll use pictures to describe it:

Data range for dates is B4 to M4. There are 12 different dates total. But when I check the Chart for this data, there are dates that I have not inserted, for example 06.06.2012. Can anyone help?

Villeroy · Posted: Sat Jun 09, 2012 1:01 am Post subject:

I doubt that you can build a proper chart from this cross-table layout. This is too complex to process. Use a most simple table such as:

Date | Name | Value

which allows you to use dozends of tools for data analysis and charting.
For instance Calc can generate a cross-table from this list and show calculation results by weeks, months, quarters, years, names.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

TaurusOoo · General User Joined: 23 Feb 2012 Posts: 5

Little update to this problem:

This happens with OO 3.4 but with OO build 3.3 the chart dates are right.

So back to 3.3 it is then.

Villeroy · Posted: Fri Jun 15, 2012 6:20 am Post subject:

And the developers don't have any chance to fix the problem unless YOU don't report anything.
https://issues.apache.org/ooo/
register, report new issue, attach a simple file demonstrating the issue.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

TaurusOoo · General User Joined: 23 Feb 2012 Posts: 5

regina · General User Joined: 24 Jul 2005 Posts: 17

Set the scale type for the x-Axis to "Text".