Issue 36172 - Cannot Change X-Axis Tick Label in Line Charts
Summary: Cannot Change X-Axis Tick Label in Line Charts
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P2 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-10-27 07:07 UTC by r_vinoya
Modified: 2013-02-24 21:22 UTC (History)
1 user (show)

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


Attachments
screen capture of line chart (9.95 KB, image/gif)
2004-10-27 07:13 UTC, r_vinoya
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description r_vinoya 2004-10-27 07:07:35 UTC
Hello,
Our division is migrating from MS Application into OpenOffice... we frequently 
use Spreadsheet document and word processor. In spreadsheet we usually use 
charts.

Anyway my issue is that I cannot change X-Axis tick labels in a line chart. 
Previously on excel this could easily be done by editing the category (x) axis 
label of the source data. I cannot seem to do this on Calc charts.
By default the x-axis tick label is "Rowxxx" which is not very descriptive when 
using the chart (see image below):

[img]http://img.villagephotos.com/p/2004-10/859324/linecategory.gif[/img]

By the way I am using OO1.1.1.
Comment 1 r_vinoya 2004-10-27 07:13:45 UTC
Created attachment 18682 [details]
screen capture of line chart
Comment 2 Regina Henschel 2004-10-27 09:56:37 UTC
The range must include the label column, in your example $B$3:$C$6. Then check
'FirstColumn as label' in the first step of 'AutoFormat Chart'.
You can discuss such problems in mailinglists and forums, see your native
language project or use users@openoffice.org (start on
http://www.openoffice.org/mail_list.html).
Comment 3 r_vinoya 2004-10-28 02:22:45 UTC
To regina...

Ok.. I'm sorry I did not see it. But in your case, you have to "RE-CREATE" the 
chart. But when EDITING EXISTING chart, the option 'FirstColumn as label' is 
not available, in which what I was doing before that's why I filed the issue.

I still say this still needs some improvement.

Anyway thanks for the suggestions and help you made. 
#:-)  
Comment 4 r_vinoya 2004-10-28 04:04:58 UTC
Issue resolved...

Just some complications... Instead of changing 'FirstColumn as label' in 
AutoFormat Chart for existing chart... This can be found in "Modify Data 
Range"... 
Well just get mixed up... Wheew!
Comment 5 kla 2004-10-29 11:56:35 UTC
-> Regina: Thanks
-> r_vinoya: I close it, ok?
Comment 6 kla 2004-10-29 11:56:49 UTC
closed