After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 663717 - choice of bar chart minimum x-axis
choice of bar chart minimum x-axis
Status: RESOLVED FIXED
Product: libgoffice
Classification: Other
Component: Graphing / Charting
unspecified
Other Linux
: Normal normal
: ---
Assigned To: Jean Bréfort
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2011-11-09 18:19 UTC by Andreas J. Guelzow
Modified: 2015-03-25 00:23 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
A possible solution (640 bytes, patch)
2011-11-09 19:35 UTC, Jean Bréfort 		committed Details | Review

Description Andreas J. Guelzow 2011-11-09 18:19:06 UTC 
1) new spreadhseet
2) type 6 following cells:

a 310 360
b 310 363

3) select with mouse, click graph, select bars

result: horizontal axis starts at "300"

I find this a very unfortunate choice of a minimum value. the x-axis in this case is the value axis. These charts are used to compare the values and having the bars shortened by 300 creates a misleading chart. We teach to avoid such presentations and if they are necessary to clearly indicate that the bars have been shortened. I do not think that libgoffice should create such shortened bars by default!
Comment 1 Jean Bréfort 2011-11-09 18:45:21 UTC 
This behavior is common to all plot types.
Comment 2 Andreas J. Guelzow 2011-11-09 18:54:55 UTC 
This is very, very unfortunate. And apparently until 1.10.16 or so it didn't use to be the case.

This makes Gnumeric's charting virtually unusable for our Statistics classes since the default collides with our teaching.
Comment 3 Jean Bréfort 2011-11-09 19:35:47 UTC 
Created attachment 201090 [details] [review]
A possible solution

The test on dim_num is far from reliable. It works for now.
Comment 4 Andreas J. Guelzow 2011-11-10 18:37:32 UTC 
This patch would do the job for bar and column charts...
Comment 5 Jean Bréfort 2011-11-10 18:42:20 UTC 
and the same for line and area charts.
Comment 6 Jean Bréfort 2011-11-14 09:55:45 UTC 
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.
Comment 7 Morten Welinder 2011-11-15 18:29:52 UTC 
Can this code grow a comment, please?  At least a reference to this bug.
Comment 8 Jean Bréfort 2011-11-15 19:09:49 UTC 
yes, will do.
Comment 9 Morten Welinder 2011-11-18 02:07:13 UTC 
Reopening.

This hits xy scatter plots now.

A1:A3=5,4,6
B1:B3=2,2,3
Select A1:A3 and make an xy graph.

--> both axes are forced to contain 0.

I don't think we want that.
Comment 10 Morten Welinder 2011-11-18 02:16:00 UTC 
Reopening.

This hits xy scatter plots now.

A1:A3=5,4,6
B1:B3=2,2,3
Select A1:A3 and make an xy graph.

--> both axes are forced to contain 0.

I don't think we want that.
Comment 11 Jean Bréfort 2011-11-18 06:14:17 UTC 
This was already the case. Not related to this bug.
Comment 12 Morten Welinder 2011-11-18 18:59:57 UTC 
My values were just too close to (0,0)
Comment 13 Morten Welinder 2015-03-25 00:23:44 UTC 
I have updated this to not force 0 for a log axis.