Customising Gantt Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all,

I've been able to produce a Gantt chart, sort of like I want it to be by
using this macro: http://support.microsoft.com/kb/213447. However I need to
do some tweaking:

I want task 2 to start where task 1 ended, etc. Somehow I'm not able to
figure it out

Thnx!
The Red Special
 
well, here's catch: I'm not really using a Gantt Chart, I'm misusing it to
accumulate an effect in $ or €

The data looks like this:
start "duration" end
0 187 187
187 -200 -13
-13 -50 -63
-63 25 38
38 100 138
138 -62 76

which would hopefully result in a graph like this:
 
The example chart has 3 stacked elements with the first series having no
fill or border to give the other 2 series the impression of floating.
With values that go negative the bars a based from the zero base line going
left rather than left from the end of the previous series.

This means you will need more complicated formula to 'pad' the series.
Jon also has a page on stacks crossing the zero boundary.
http://peltiertech.com/Excel/Charts/StackedColumnsAboveAndBelow.html

Cheers
Andy
 
seems exactly to be what I need, couldn't think of the name waterfall chart
I'll de a post if it worked out

thanks for your *fast* response
 
Thanks: it was just what I needed - have been able to create the chart I want
with my own data...

I'll asking a co-worker to turn it into a macro, 'cause we'll be using way
more
 
Back
Top