Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | user defined text labels for specific values on axis - vlookup | ||
---|---|---|---|
Product: | General | Reporter: | adic <adrian> |
Component: | chart | Assignee: | AOO issues mailing list <issues> |
Status: | CONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P4 | CC: | issues, kozodaevroman, tony.galmiche.ooo |
Version: | 3.3.0 or older (OOo) | Keywords: | rfe_eval_ok |
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
adic
2004-04-29 08:13:25 UTC
Hi Bettina, one for you. tk Reassigned to Ingrid. ->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? 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. 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 http://specs.openoffice.org/chart/dataselection/FlexibleSourceRangeSelection.sxw. 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. *** Issue 51213 has been marked as a duplicate of this issue. *** *** Issue 64703 has been marked as a duplicate of this issue. *** changed prio reset to new *** Issue 106377 has been marked as a duplicate of this issue. *** |