software

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
I'd suggest doing this similar to a Gantt chart.

www.peltiertech.com/Excel/Cha...tml#GanttChart

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

quot;Stevequot; gt; wrote in message hlink.net...
gt; Can the following be plotted in a pivot chart?
gt;
gt; John's Vacation 2005 --
gt;
gt; 10/12/05 to 10/17/05
gt; 11/5/05 to 11/18/05
gt; 12/16/05 to 12/31/05
gt;
gt; I'd like the dates 10/1/05 to 12/31/05 across the top and the vacation
gt; periods shown as horizontal bars.
gt;
gt; Thanks,
gt;
gt; Steve
gt;
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,

Stevequot;Barb Reinhardtquot; gt; wrote in message
...
gt; I'd suggest doing this similar to a Gantt chart.
gt;
gt; www.peltiertech.com/Excel/Cha...tml#GanttChart
gt;
gt; It's functionally a stacked bar chart with some of the bars hidden.
gt;
gt; quot;Stevequot; gt; wrote in message
gt; hlink.net...
gt;gt; Can the following be plotted in a pivot chart?
gt;gt;
gt;gt; John's Vacation 2005 --
gt;gt;
gt;gt; 10/12/05 to 10/17/05
gt;gt; 11/5/05 to 11/18/05
gt;gt; 12/16/05 to 12/31/05
gt;gt;
gt;gt; I'd like the dates 10/1/05 to 12/31/05 across the top and the vacation
gt;gt; periods shown as horizontal bars.
gt;gt;
gt;gt; Thanks,
gt;gt;
gt;gt; Steve
gt;gt;
gt;
gt;