Issue 28503 - user defined text labels for specific values on axis - vlookup
Summary: user defined text labels for specific values on axis - vlookup
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P4 Trivial with 37 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: rfe_eval_ok
: 106377 (view as issue list)
Depends on:
Reported: 2004-04-29 08:13 UTC by adic
Modified: 2013-09-25 20:41 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description adic 2004-04-29 08:13:25 UTC

I would like to ask for an imprivement in the way charts are drawn, and more
specifically the axis numbering system.
This are 3 descriptions of what I would like to have in OO:

1. Allow more than 3 conditional formats in custom number formats
2. Be able to specify a user defined list as a number format, where 0=first
entry, 1 = second and so on
3. Some kind of vlookup type table to return appropriate text strings.

I want that for example on the Y axis to have instead of (0,1,2,3,4) any text
for each value like (AA, AB, AC, AD, AE) and to be able to assign for each axis
value a text string which will appear on that axis instead of the value.

Comment 1 kla 2004-04-30 09:54:07 UTC
Hi Bettina,
one for you.
Comment 2 bettina.haberer 2004-11-29 18:19:10 UTC
Reassigned to Ingrid.
Comment 3 IngridvdM 2005-04-19 13:12:30 UTC
->adic: Could you please give an example how you want to use this three
different features? Especially I would like to know wether you are looking for
categories at two axis at the same time or categories only at the y axis? In the
latter case a mirrored line chart with swapped x and y axis would be what you
are looking for with the second request. Is that right?
Comment 4 adic 2005-04-19 14:23:48 UTC
iha: An example of use:

- draw a chart where on the X axis I have the dates when the students of a
classroom took exams, and on the Y axis I have their grades in this scale:
Insufficient, Sufficient, Good, Very Good. I would like that Insufficient to be
represented like it would be equal to 0 ... Very Good as 3, so that on the Y
axis to only have the text grades, and not 0,1,2,3.

- for the X axis I could want to have some text too instead of the actual
values, like EXAM_1 instead of 22.08.2004 and so on.

Comment 5 IngridvdM 2005-04-19 17:53:19 UTC
Thank you for the fast response :-). So I guess each student would be a line in
your example and you can see his improvements over time. Thats a nice example.

to 2) Having a list of n texts for the values 0 to n on an axis is already an
exsisting concept called categories. It is not very flexible at the moment. You
need to have those texts listet in the first row or column of your data range.
This will be improved within Issue 3997. Maybe you want to have a look at the
specification at
This concept might not be excaclty what you need but I fear that there would be
to much confusion if we indroduce another similar system here. So I tend to not
offer this but instead concentrate on your request 3). Because you can get 2)
when having 3):

to 3) I assume that having a vlookup like method to replace values could be a
powerful method to create customized axis labels. We should consider this.
Details have to be specified. As I would like to concentrate on this idea within
this Issue I changed the summary accordingly.

to 1) 'er' is the one working on the number formatter. He tends to not touch the
limit to three conditions in numberformats. Maybe you would like to try to
convince him yourself. In that case please do submit a separat Issue to him.
Thank you for you input.
Comment 6 kla 2005-07-14 13:03:54 UTC
*** Issue 51213 has been marked as a duplicate of this issue. ***
Comment 7 IngridvdM 2006-04-25 11:00:06 UTC
*** Issue 64703 has been marked as a duplicate of this issue. ***
Comment 8 IngridvdM 2006-04-26 11:51:23 UTC
changed prio
Comment 9 IngridvdM 2008-07-22 14:20:57 UTC
reset to new
Comment 10 IngridvdM 2010-06-15 12:22:02 UTC
*** Issue 106377 has been marked as a duplicate of this issue. ***