Charting Date Ranges

  • Thread starter Thread starter Enigmatic
  • Start date Start date
E

Enigmatic

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