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?

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/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?
>
>

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 here:
> 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?
> >
> >

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.

--
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 here:
> > 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?
> > >
> > >