Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Component:||chart||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||ahz001, bugger_aoo, issues, pagalmes.lists, tony.galmiche.ooo|
|Version:||3.3.0 or older (OOo)||Keywords:||oooqa, rfe_eval_ok|
|Issue Type:||FEATURE||Latest Confirmation in:||---|
Description bfriedr 2003-01-16 09:30:28 UTC
Sirs, I am missing horizontal bars (called balance beams in excel). If x-axis is date and y-axis is country you can create charts for public hollidays for example - showing when (from - to) summer hollidays will be in each country. Also needed for creating time schedules in workflow charts. Regards, B. Friedrichs
Comment 1 kla 2003-01-17 09:34:16 UTC
I take it.
Comment 2 kla 2003-01-17 09:34:54 UTC
Hi Bettina, one for you.
Comment 3 eric.savary 2003-04-16 15:30:58 UTC
Set to "NEW"
Comment 4 bettina.haberer 2004-11-29 18:02:38 UTC
Reassigned to BjÃ¶rn.
Comment 5 bjoern.milcke 2005-01-28 17:09:44 UTC
->IHA: Sending you these issues so that all unconfirmed enhancements and features are at one place.
Comment 6 IngridvdM 2005-02-09 16:56:12 UTC
Yes, we should implement this feature in future. For the moment you can try a workaround: Create a stacked horizontal bar chart with two series. Than make the first series invisible (set border style and area fill to none ) and switch of the legend.
Comment 7 IngridvdM 2005-02-17 09:13:25 UTC
Comment 8 bfriedr 2005-06-03 14:42:07 UTC
Well, this seams to be a dead feature. And your recommodation does not work... Imagine a scale (horizontal) June, July, August and than stacked horizontal bars for Germany, France, Italy; Title main hollidays. How no create the German bar starting from mid July to end of August....? I have attached one graphics from my geophysical work. Regards, B. Friedrichs
Comment 9 bfriedr 2005-06-03 14:43:28 UTC
Created attachment 26862 [details] contains a snapshot of the desired feature
Comment 10 IngridvdM 2005-06-06 09:58:26 UTC
I am not sure what you are meaning with 'dead feature'? It is intended to implement this feature but this will probably not happen in very near future. For your difficulties with the workaround I can only guess 2 reasons: 1) The time scale that you need for your example is not available in OpenOffice Chart. This feature is targeted with Issue 25706. 2) How to create the two necessary series for your example was not made clear by me. So I try again: To work around the missing time scale you may choose calendar weeks in numbers instead of dates for example. Than you need to create two series where the first series has the week numbers from the start and the second series has the numbers of the end of each of your bars. For example for the german bar the first series has number 28 for a week in mid July and the second series has the number 35 for end August. Now stack the series one upon each other and make the first series invisible. Hope that helps.
Comment 11 IngridvdM 2005-06-06 12:00:37 UTC
Grrr sorry, I need to correct myself, of course the value for the second series needs to be the difference between end of August and mid July, so it needs to be 6 weeks.
Comment 12 bfriedr 2005-06-07 06:50:46 UTC
Yes, that comes close to a possible solution: giving openoffice the possiblity to make the fist data column invisble; second column would just contain the length: chart hollidays week Germany Italy 28 29 6 30 31 5 create a stacked chart ... only display and label of "week" must be suppressed now... but how? Bernhard
Comment 13 IngridvdM 2005-06-07 10:35:25 UTC
Try to create your data as follows in the spreadsheet: Germany France Italy 28 35 31 6 8 5 The first line of values are the weeks where the holiday starts. The second line of values are the duration of the holidays in weeks. Than choose insert chart from the menu. Click next. Choose the chart type Bars by clicking on the Bars icon. Choose 'Data series in: Rows'. Click Next. Click on the icon named 'Stacked'. And click create. Select the blue series, open the Object Properties dialog and choose Border Style Invisible and Area Fill None. Hope that helps.
Comment 14 bfriedr 2005-06-07 14:56:24 UTC
Yes! I got it know. Now I can use it also for my geophysical data where I compare overlapping measurement times . Thank you very much, Bernhard
Comment 15 aziem 2005-10-05 20:16:31 UTC
I fixed summary spelling to make this more searchable.
Comment 16 IngridvdM 2006-03-07 12:50:41 UTC
*** Issue 62364 has been marked as a duplicate of this issue. ***
Comment 17 IngridvdM 2008-07-22 14:21:39 UTC
reset to new