create bar in timeline like a Gantt

B

Bob A

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Gantt chart duration not showing 0
Remove title bar and phase bar by default on swimlane 0
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0
Creating a Search using a combo box and then creating a report. 4
Please Help: color coding a timeline graph 0
Printing a specific date & hour in project 0
Change symbols in a Network Diagram legend. 0
2010 Multiple Timeline Views in 1 Master 0

Top