Create a Chart using a Macro

[Scott_goddard]

Hi all,

I would like automatically generate a Gantt style graph though use of a
Macro and a little button. I have the following data

Task description
Start date
End date
% completed
% remaining.

Does anyone have some code that I can just use?

 

[trip_to_tokyo]

EXCEL 2007

Scott, I don't have a Macro but there is a GANTT chart available at:-

http://www.pierrefondes.com/

Item Number 78.

You might like to download this.

If my comments have helped please hit Yes.

Thanks.