Issue 120924 - anchor first x-value to y-axis
Summary: anchor first x-value to y-axis
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2012-09-12 21:57 UTC by Raymond Rigo
Modified: 2013-02-24 21:21 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Spread sheet showing the chart with floating x-values. (31.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-09-12 21:57 UTC, Raymond Rigo
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Raymond Rigo 2012-09-12 21:57:17 UTC
Created attachment 79445 [details]
Spread sheet showing the chart with floating x-values.

Running Windows 7 SP 1 on an HP Pavilion G7. Open Office 3.4.1

Previous to Open Office 3.4.1 when I created a chart from my data the first x-value was always anchored to the y-axis. Since installing Open Office 3.4.1 the x values in my chart float and center themselves on the x-axis. Also the x-values are dates that I exercise and if I miss a day I do not put it into the data for the chart but now the chart inserts those missing days with no data points and it screws up my charts. This has only happened since I installed Open Office 3.4.1 before that it worked just fine. I have put this on the help forums under the topic 'anchor first x-value to the y-axis' and have not gotten a solution to this problem. 

I have attached a sample of one of my spread sheets so you can see what I am talking about.

Thank you in advance.
Comment 1 Shan Zhu 2012-11-09 09:35:58 UTC
(In reply to comment #0)
Hi, Raymond

This problem is all about the format of the x axis labels.
In your sample file, the Date has been used as label of x axis.
In fact, the value of Date is a type of number. In this case, all the values of your date are greater than 0. It makes the start of the line can not anchor to Y axis.

A solution for your reference:
Change the Date into text. Several ways can do it. For example, add character ' before the date. 
Then create chart, the result will be what you want.

If it can resolve your problem, can I close this defect? Thanks.
Comment 2 Edwin Sharp 2013-02-01 11:23:23 UTC
Right click on Y - Format Axis... - Positioning - Axis line cross other axis at value 03/09/2012 doesn't help.
Right click on X - Format Axis... - Scale - Type = Date and Minimum = 03/09/2012 also doesn't help.
Can not think on a possible remedy for the missing days.