Charting Date Ranges

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Enigmatic - 25 Nov 2003 16:13 GMT

Trying to chart a series of date ranges (sort of in a timeline-typ
fashion). Chart keeps showing beginning and end dates as two separat
bars. I need them to span the entire year showing what amount of tim
they take up.

Where am I going wrong?

Eni

+----------------------------------------------------------------
| Attachment filename: chart1.jpg
|Download attachment: http://www.excelforum.com/attachment.php?postid=366530
+----------------------------------------------------------------

Reply to this Message

Jon Peltier - 25 Nov 2003 17:25 GMT

Enig -

Your data should be Campaign Start, and Duration (which is Ad Order
Close minus Campaign Start). Plot this data the way you already have,
but in a stacked bar chart, not a clustered bar chart. Then double
click on the Start series, and on the Patterns tab, select None for
Border and for Fill, to make this series invisible.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> Trying to chart a series of date ranges (sort of in a timeline-type
> fashion). Chart keeps showing beginning and end dates as two separate
[quoted text clipped - 11 lines]
>
> ------------------------------------------------

Reply to this Message