Charting possibility

[debraj]

Hi,

Is there a way to chart a series of data along with markers for
specific events.. something similar to what http://finance.google.com
have.

Essentially how can this data be charted in the most informative way
using excel?

Month Value Event
Jan 80
Feb 75
Mar 25 Pilot study implemented
Apr 30
May 56 Next version released
June 67
July 82

Thanks,
Debraj

 

[Bernard Liengme]

See Jon's stuff at
http://peltiertech.com/Excel/Charts/ComboCharts.html#AddLine
best wishes

 

[Del Cotter]

Essentially how can this data be charted in the most informative way
using excel?

Month Value Event
Jan 80
Feb 75
Mar 25 Pilot study implemented
Apr 30
May 56 Next version released
June 67
July 82

I can't find it now, but somewhere out there is a good guide to creating
these things. The example I saw used a history of oil prices from 1770
to the present day.

Basically, you need to create a point for the event labels, and a line
length between the event label and the value point:

Month Value Eventpoint Dropline Event
Jan 80
Feb 75
Mar 25 110 85 Pilot study implemented
Apr 30
May 56 110 54 Next version released
June 67
July 82

Make a second line range for "eventpoint". Give it error bars of length
"dropline". Then use one of the available Excel add-ins to assign those
points a data label equal to "Event". Then make the points invisible,
because all you want to show is the Event and the connecting line.

 

[Andy Pope]

Hi,

Maybe something like this,
http://www.andypope.info/ngs/ng47.htm

Cheers
Andy

 

[debraj]

Thanks Andy and Del,

This worked out for me.

Debraj

 

[Del Cotter]

Update: the example I was looking for is from Kelly O'Day's web site:

http://processtrends.com/pg_charts_trend_with_events.htm