Microsoft Excel 2007: How can I create a time line graph with marker Flags
Posted on 2011-02-22
I would like to be able to do the following type of chart using Excel 2007.
Suppose I have two columns as follows. Column A has the number of tickets my sold on a given day. Column B has the date in as a date format variable.
I know how to convert this to a line graph showing ticket sales over time. Let's suppose the lines are more or less horizontal - going up or down as the ticket sales get closer to the event itself. What I want to do is put in some vertical lines showing. events that happened on particular dates. For example if on January 15th we did an email campaign on a particular subject I would like a white rectangle at the top of the vertical line marker explaining what happened on that date. You frequently see the same type of display in newspapers.
Can anyone explain how to do this in Excel 2007?