Issue 82727 - Range of x axis too high in xy scatter, please make this customazable
Summary: Range of x axis too high in xy scatter, please make this customazable
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.4.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-10-17 19:52 UTC by dudson
Modified: 2014-02-20 18:08 UTC (History)
2 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: 4.0.1
Developer Difficulty: ---

A, ods file which shows two example graphs (21.23 KB, text/plain)
2007-10-17 19:58 UTC, dudson
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description dudson 2007-10-17 19:52:58 UTC
When making a graph from some data in a calc sheet. 
The Graph wizard at the end makes the x-scale too large.
(see example, it should stop at 24 but for some reason it continues to 30)

This is not very pleasant behaviour, knowing there is space on paper wasted when
this is printed out.
Comment 1 dudson 2007-10-17 19:58:50 UTC
Created attachment 48975 [details]
A, ods file which shows two example graphs
Comment 2 dudson 2007-10-17 20:25:25 UTC
It always goes 6 too high on the x-axis
Comment 3 kla 2007-10-19 09:44:48 UTC
@bm: I think the way we are use is the better one, but maybe we can discuss it. 
Comment 4 dudson 2007-10-19 16:42:23 UTC
The best way to settle this is making it a setting in settings/charts, 
then the user can specify how much extra space he or she wants on the x and
other axes. 
Comment 5 dudson 2007-10-19 17:38:59 UTC
Is what I described just above a good idea to solve this?
Comment 6 dudson 2007-10-20 17:27:21 UTC
(for each diagram type independent settings please)
(This way each diagram has it's own settings because the different kinds of
diagrams are often being used with a certain function and there are differences
in if there should be extra space on the axes.)
Comment 7 bjoern.milcke 2007-10-23 13:00:33 UTC
The behavior is the same as in Excel. However, I admit that it is not nice, the
extra tick on the right does not make much sense at the x-axis.

So, pro: looks better, con: different from Excel.

(see bool-flag  ScaleAutomatism::m_bExpandIfValuesCloseToBorder which controls
this behavior)
Comment 8 bjoern.milcke 2007-10-23 13:04:02 UTC
... meaning pro and con for changing the behavior. An option would also be
possible to think of. Then, we can import Excel files correctly and still use a
better default. Would make sense to add this to the axis options dialog.
Comment 9 dudson 2007-10-27 15:54:32 UTC
That's a good idea.
Together with other chart options in the settings menu.
Comment 10 dudson 2007-10-27 16:09:42 UTC
But mayby this issue is than a duplicate of 
issue 12581: Customizable chart defaults
Comment 11 IngridvdM 2008-07-03 11:39:48 UTC
change owner
Comment 12 dudson 2013-09-27 21:52:55 UTC
It being able to set the axis ranges in the wizard would be the most practical thing.
Being able to set it with typing in numbers or referring to a cell.
And have as default the current value.
Defaults should be specifiable in options/settings of AOO.