Apache OpenOffice (AOO) Bugzilla – Issue 10704
gantt chart
Last modified: 2013-09-25 20:41:38 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
I take it.
Hi Bettina, one for you.
Set to "NEW"
Reassigned to Björn.
->IHA: Sending you these issues so that all unconfirmed enhancements and features are at one place.
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.
.
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
Created attachment 26862 [details] contains a snapshot of the desired feature
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.
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.
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
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.
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
I fixed summary spelling to make this more searchable.
*** Issue 62364 has been marked as a duplicate of this issue. ***
reset to new