I would really appreciate your help. I have a weird one! I have built a
horizontal time line at the top of an Excel sheet. VBA code collects the
start and end dates of a date range. How can I build a bar on the row below
the time line, like in a Gantt chart? I would also like to put a name within
the bar. Collecting the start and end dates, navigating to the timeline
sheet and the row below the time line is OK, but I can’t find the code for
creating the bar. Knowing the start and end dates I guess I could relate
them to the spreadsheet columns, but how do I connect them with a bar?
--
Bob A

This might give you some ideas

http://spreadsheetpage.com/index.php...tt_chart_demo/

Ken


On Dec 28, 4:03*pm, Bob A <B...@discussions.microsoft.com> wrote:
> I would really appreciate your help. *I have a weird one! *I have built a
> horizontal time line at the top of an Excel sheet. *VBA code collects the
> start and end dates of a date range. *How can I build a bar on the row below
> the time line, like in a Gantt chart? *I would also like to put a name within
> the bar. *Collecting the start and end dates, navigating to the timeline
> sheet and the row below the time line is OK, but I can’t find the code for
> creating the bar. *Knowing the start and end dates I guess I could relate
> them to the spreadsheet columns, but how do I connect them with a bar?
> --
> Bob A

http://www.youtube.com/watch?v=HQwE0Xv1lAA

http://www.youtube.com/watch?v=CW_wGSFavTc

Lots of others out there; just Google around...

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


"Ken" wrote:

> This might give you some ideas
>
> http://spreadsheetpage.com/index.php...tt_chart_demo/
>
> Ken
>
>
> On Dec 28, 4:03 pm, Bob A <B...@discussions.microsoft.com> wrote:
> > I would really appreciate your help. I have a weird one! I have built a
> > horizontal time line at the top of an Excel sheet. VBA code collects the
> > start and end dates of a date range. How can I build a bar on the row below
> > the time line, like in a Gantt chart? I would also like to put a name within
> > the bar. Collecting the start and end dates, navigating to the timeline
> > sheet and the row below the time line is OK, but I can’t find the code for
> > creating the bar. Knowing the start and end dates I guess I could relate
> > them to the spreadsheet columns, but how do I connect them with a bar?
> > --
> > Bob A
>
> .
>