Issue 10704 - gantt chart
Summary: gantt chart
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All Linux, all
: P3 Trivial with 8 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa, rfe_eval_ok
: 62364 (view as issue list)
Depends on:
Reported: 2003-01-16 09:30 UTC by bfriedr
Modified: 2013-09-25 20:41 UTC (History)
5 users (show)

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

contains a snapshot of the desired feature (83.85 KB, application/
2005-06-03 14:43 UTC, bfriedr
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description bfriedr 2003-01-16 09:30:28 UTC
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

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.

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

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
29      6
31               5

create a stacked chart ... only display and label of "week" must be suppressed
now... but how?

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
I got it know. Now I can use it also for my geophysical data where I compare
overlapping measurement times .
Thank you very much,
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