Charting possibility

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

debraj - 05 Sep 2006 19:22 GMT

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

Reply to this Message

Bernard Liengme - 05 Sep 2006 19:41 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Hi,
>
[quoted text clipped - 16 lines]
> Thanks,
> Debraj

Reply to this Message

Del Cotter - 06 Sep 2006 00:22 GMT

>Essentially how can this data be charted in the most informative way
>using excel?
[quoted text clipped - 7 lines]
>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.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Reply to this Message

Del Cotter - 08 Sep 2006 23:29 GMT

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

http://processtrends.com/pg_charts_trend_with_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.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Reply to this Message

Andy Pope - 06 Sep 2006 08:42 GMT

Hi,

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

Cheers
Andy

> Hi,
>
[quoted text clipped - 16 lines]
> Thanks,
> Debraj

Signature

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

Reply to this Message

debraj - 08 Sep 2006 20:36 GMT

Thanks Andy and Del,

This worked out for me.

Debraj

> Hi,
>
[quoted text clipped - 24 lines]
> > Thanks,
> > Debraj

Reply to this Message