Issue 113725 - Chart Inverts Columns In Bar Modality
Summary: Chart Inverts Columns In Bar Modality
Status: RESOLVED FIXED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: morvan
QA Contact:
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2010-08-07 23:14 UTC by morvan_br
Modified: 2013-07-29 12:59 UTC (History)
3 users (show)

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

Attachments
SpreadSheet containing Chart (Bar) with inverted values (30.00 KB, text/plain)
2010-08-09 02:40 UTC, morvan_br 		no flags Details
modified chart directions (31.90 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-08-09 11:38 UTC, Regina Henschel 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description morvan_br 2010-08-07 23:14:16 UTC 
In Calc, such file and several simulations, Calc Chart Component inverts
columns. If you have a spreadsheet - say - with 20 cities, and generate a chart
with data, that such names and incomings from it, first city - in the chart, is
the last one. A client at my work sent me a file to try to fix the chart
direction, no success. The workaround I made was to invert (sorting) the
spreadsheet data, to see if inside chart that worked. When I tried other
modalities of chart, they worked no problem.

Regards,

Morvan
Comment 1 Rainer Bielefeld 2010-08-08 08:33:11 UTC 
@morvan_br:
Please attach a sample document!
Comment 2 morvan_br 2010-08-09 02:40:08 UTC 
Created attachment 71013 [details]
SpreadSheet containing Chart (Bar) with inverted values
Comment 3 Regina Henschel 2010-08-09 11:38:17 UTC 
There are two settings to influence the direction
(1) Format > Axis > Tab 'Scale' > Checkbox 'Reverse direction'
(2) Format > Axis > Tab 'Positioning' > List 'Cross other axis at'

I'm not sure what you want to get, but I'll attach a modified chart, so that you
can see the effect of those settings.
Comment 4 Regina Henschel 2010-08-09 11:38:59 UTC 
Created attachment 71017 [details]
modified chart directions
Comment 5 morvan_br 2010-08-11 23:49:00 UTC 
Thanks everybody.
Regina, your solution works. My client stood satisfied with results. Interesting
I had seek the same approach and failed. Maybe I did have to use the two
directions you quoted - no puzzle words... But I continue thinking the behaviour
is not satisfactory. Bar graphic ought to get A to B; why B to A?
My doubt is if it is now a defect or a feature to get working.
All suggestions are welcome.

Morvan, User Linux #433640
Comment 6 Rob Weir 2013-02-02 03:00:06 UTC 
This Issue requires more information ('needmoreinfo'), but has not been updated
within the last year. Please provide feedback as requested and re-test with the the latest version of OpenOffice - the problem(s) may already be addressed. 

You can download Apache OpenOffice 3.4.1 from http://www.openoffice.org/download

Please report back the outcome of your testing, so this Issue may be closed or
progressed as necessary - otherwise the issue may be Resolved as Invalid in the
future.
Comment 7 morvan_br 2013-02-02 15:57:54 UTC 
Good afternoon.

I tested (with attached file I put) and direction continues to go upside down. I think Graphs must plot first item on first place. Simple as is.
Solution Regina showed worked too good. But, if software plots first item in first place, is the correct to do.

Best regards,

Morvan.
Comment 8 Edwin Sharp 2013-07-29 12:59:22 UTC 
Chart values are ordered according to table data.

Rev. 1505643 Win 7