Create an auto chart using 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?

 

[ryguy7272]

Haha, I think it's going to be a little more complex then you think it's
going to be. Start here:
http://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html

You should probably get acquainted with that. There's a video there too.
May be a good learning experience, but I think you already know a bit about
Gantt Charts. So, anyway, that may give you some ideas, but the most helpful
thing would probably be to record a macro as you go through the steps of
creating your charts. The macro recorder will literally 'record' everything
as you step through your routine.

Take a look at this too:
http://www.anthony-vba.kefra.com/vba/vbabasic1.htm#Recording_Your_First_Macro

 

[Scott_goddard]

I know a little about the charts but i can only find ones that use days
completed and days remaining. I would like to use % completed and %
remaining...any ideas?

 

[ryguy7272]

Percent complete? I think there's a sample here:
http://peltiertech.com/Excel/Charts/GanttChart.html

You may have to do a bit of work to get the results you want, but that's
probably a very good start.