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

See Jon's stuff at
http://peltiertech.com/Excel/Charts/...s.html#AddLine
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"debraj" wrote in message
oups.com...
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

On Tue, 5 Sep 2006, in microsoft.public.excel.charting,
debraj said:

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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Hi,

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

Cheers
Andy

debraj wrote:
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


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks Andy and Del,

This worked out for me.

Debraj


Andy Pope wrote:
Hi,

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

Cheers
Andy

debraj wrote:
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


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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

http://processtrends.com/pg_charts_t...ith_events.htm

On Wed, 6 Sep 2006, in microsoft.public.excel.charting, I said:
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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.