Charting Date Ranges

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
+----------------------------------------------------------------

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

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
_______

Enigmatic wrote:

> 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
> bars. I need them to span the entire year showing what amount of time
> they take up.
>
> Where am I going wrong?
>
> Enig
>
>
> +----------------------------------------------------------------+
> | Attachment filename: chart1.jpg |
> |Download attachment: http://www.excelforum.com/attachment.php?postid=366530|
> +----------------------------------------------------------------+
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>