Create an auto chart using macro
 

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?

Create an auto chart using macro
 

Haha, I think it's going to be a little more complex then you think it's
going to be. Start he
http://www.vertex42.com/ExcelTemplat...ntt-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...ur_First_Macro
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Scott_goddard" wrote:

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?

Create an auto chart using macro
 

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" wrote:

Haha, I think it's going to be a little more complex then you think it's
going to be. Start he
http://www.vertex42.com/ExcelTemplat...ntt-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...ur_First_Macro
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Scott_goddard" wrote:

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?

Create an auto chart using macro
 

Percent complete? I think there's a sample he
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.

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Scott_goddard" wrote:

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" wrote:

Haha, I think it's going to be a little more complex then you think it's
going to be. Start he
http://www.vertex42.com/ExcelTemplat...ntt-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...ur_First_Macro
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Scott_goddard" wrote:

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?