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 Timeline 1
Gantt Charting 4
Gantt Code Needed 1
Gantt charts on Excel Spreadsheet 2
Timeline/gantt 1
Excel Gantt Chart. Schedule vs Actual 2
Chart with Timeline Using Week1, Week2, etc. 2
Dynamically Scale Gantt Chart Time Scale 2

Top