Axis scales in diagrams

user957 · General User Joined: 13 Jul 2010 Posts: 16

Hi

I have a short table in calc I need to make into a diagram of 3 graphs. I took measurements of a 3 plants with varying time in between measurements. Sometimes 2 days, sometimes 4 days etc. I put the dates on the X- axis, however there is the same distance between every date, which isn't correct.

I did find the 'edit X- axisl' option but everything on the 'scale' tab is greyed out.

I'm using the swedish version so the translations may not be perfect and that's why I'm not finding the right path here...

I have OO 3.3.0 on WinXP SP3.

Oh and also, why can't I type i.e 28/2 for a date? (meaning 28th of feb). How do I stop it from autocorrecting these cells?

Thank you.

Villeroy · Posted: Wed Apr 06, 2011 8:30 am Post subject:

Turn your line chart into a x/y-scatter chart.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

user957 · General User Joined: 13 Jul 2010 Posts: 16

Thanks. Although this deletes one of the lines, and changes the names on both axes to numeric values (??????)...

Villeroy · Posted: Wed Apr 06, 2011 8:46 am Post subject:

It plots a numeric scale on the x-axis against a numeric scale on the y-axis.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

user957 · General User Joined: 13 Jul 2010 Posts: 16

Ok now I get it. But why is one of the graphs excluded?

user957 · General User Joined: 13 Jul 2010 Posts: 16

I uploaded the file here for anyone to take a look.
Thanks.

http://privat.bahnhof.se/wb204532/misc/upload.ods
_________________
I am on: OO 3.3.0, Win7 & House music!

ken johnson · Posted: Sat Apr 09, 2011 5:43 am Post subject:

The 2 (1 ml Al) plot is using the row 17 values for X and the row 18 values for Y.
The 3 (10 ml Al) plot is using the same X values and row 19 values for Y.
Your X axis is labelled "Date". There aren't any dates on the sheet. Maybe row 16 values (SNITT (mm)) has the X values. Just a guess.

Double click the chart then right-click it then select "Data Ranges" from the pop up menu to bring up the "Data Ranges" dialog. Use the dialog's "Data Series" tab sheet to add the missing plot and fix up the other two.

Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

user957 · General User Joined: 13 Jul 2010 Posts: 16

I had to type the dates in as 28,2 meaning 28/2 meaning february 28th, because calc wouldn't let me enter 28/2 without reformatting it to 2001-28-02 which is completely wrong and upside down and inside out. Extremely annoying. But it doesn't really matter since the XY scatter turns the dates into a numeric value anyway...............

Will try your suggestions, thanks!
_________________
I am on: OO 3.3.0, Win7 & House music!

Villeroy · Posted: Sun Apr 10, 2011 6:41 am Post subject:

I have never seen a date like 2001-28-02. Either you applied a user defined number format YYYY-DD-MM or you are running a strange office locale (Tools>OPtions...LanguageSettings>Languages>Locale)

It is impossible that 2001-28-02 is a wrong value when you entered 28th of February 2001 one way or the other way. It may be a "wrong" (unwanted) representation but the value is right. All formulas will use the right number. You can format that number in thousands of different ways without changing that value. BTW: The "true" numeric cell value is 36950 [which is "days since 1899-12-30" as you can see when you format a zero as date]

You can format your cells in many ways. Just do not expect that the program will format the cell automatically according to the flavour of your input. Such an auto-formatting will never happen.
When you enter some numeric expression into an "unformatted" cell (number format "General") the application will apply one particular date format, one particular time format, one particular decimal format depending on the set number format locale or global locale setting.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

jrkrideau · Posted: Sun Apr 10, 2011 1:53 pm Post subject:

There's no way you should be getting a date like that.

You may want to [url=http://user.services.openoffice.org/en/forum/viewtopic.php?p=58403#p58403]reset the user profile[/url . It often cures weird behaviours in OOo.

When I enter 28,2 I get a text string but I'm using a Canadian language setting where . not , is the decimal separator. Still 28/2/11 gives 28/02/11 in your sheet.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2

user957 · General User Joined: 13 Jul 2010 Posts: 16

Sorry for not being entirely accurate in my first post regarding this latest dilemma, I was probably too frustrated to think clearly. Here's exactly what happens:

"28/2" --> "28-02-01"

Why it changes to 2001 is beyond me. However, I figured out how to add a user defined format as DD/MM and it's working now.

EDIT: Spoke too soon. Even though I have a user defined date now there's a new problem;

Example: 28,2 is reformatted with DD/MM and changes to 28/02. Fine. 8,3 is reformatted with DD/MM and changes to 07/01......... WTF!? I am on my last shred of patience now. This program may be logical but it's definately not intuitive or user friendly.
_________________
I am on: OO 3.3.0, Win7 & House music!

jrkrideau · Posted: Sun Apr 17, 2011 3:42 am Post subject:

user957 · General User Joined: 13 Jul 2010 Posts: 16

Yeah maybe it's a bug. Can I report it in somewhere? Maybe the the swedish developers would like to take a look at it. I actually made a short video of it too;

http://privat.bahnhof.se/wb204532/misc/calcFAIL.avi

EDIT: Found the bug reporter page as well. It's in the following link if any reader is interested;

http://qa.openoffice.org/issue_handling/pre_submission.html
_________________
I am on: OO 3.3.0, Win7 & House music!

jrkrideau · Posted: Tue Apr 19, 2011 4:40 am Post subject: