Vacation Plotted In A Pivot Chart

[Steve]

Can the following be plotted in a pivot chart?

John's Vacation 2005 --

10/12/05 to 10/17/05
11/5/05 to 11/18/05
12/16/05 to 12/31/05

I'd like the dates 10/1/05 to 12/31/05 across the top and the vacation
periods shown as horizontal bars.

Thanks,

Steve

 

[Barb Reinhardt]

I'd suggest doing this similar to a Gantt chart.

http://www.peltiertech.com/Excel/Charts/ComboCharts.html#GanttChart

It's functionally a stacked bar chart with some of the bars hidden.

 

[Steve]

Barb,

Thank you very much for the response!!

This is probably a very simple question ----
How do I get a vacation period to display as a bar where the start date and
end date define the length of the bar?

Thanks,

Steve