Antsmarching.org Forums - Dave Matthews Band Discussion - View Single Post - Roger’s Excel Thread
View Single Post
Old 02-07-2017, 12:29 PM   #100
rconverse
 
rconverse's Avatar
 
Join Date: May 2003
Location: Pretty Boy Blue State
Posts: 77,945

Shows Seen: 25

DMB Hub Stubs: 14

My Tour Central Stats

Re: Excel Help

Quote:
Originally Posted by diableri View Post
So I need a timeline of events displayed along a horizontal line with elapsed time hash marks.

Something along the lines below. It's for individual illustrations on a case by case basis.

Anyone have any tips to get there? I've blown about an hour digging around it's definitely not intuitive. I don't have trouble with the elapsed time, I am having trouble getting a graph to look like that.

http://imgur.com/wEoHmp3
What do you mean "I don't have trouble with the elapsed time". What are you plotting on the vertical access?

Like a gantt chart?

https://www.smartsheet.com/blog/gantt-chart-excel

Last edited by rconverse; 02-07-2017 at 12:32 PM.
rconverse is offline   Reply With Quote