If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Vacation Plotted In A Pivot Chart
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 |
#2
|
|||
|
|||
Vacation Plotted In A Pivot Chart
I'd suggest doing this similar to a Gantt chart.
http://www.peltiertech.com/Excel/Cha...tml#GanttChart It's functionally a stacked bar chart with some of the bars hidden. "Steve" wrote in message hlink.net... 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 |
#3
|
|||
|
|||
Vacation Plotted In A Pivot Chart
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 "Barb Reinhardt" wrote in message ... I'd suggest doing this similar to a Gantt chart. http://www.peltiertech.com/Excel/Cha...tml#GanttChart It's functionally a stacked bar chart with some of the bars hidden. "Steve" wrote in message hlink.net... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot Chart - X,Y & Data Series Options | Graham Haslehurst | Charts and Charting | 4 | November 24th, 2005 02:51 PM |
Pivot Chart Field List Not Enabled | quackerbacker | Running & Setting Up Queries | 0 | November 18th, 2005 12:43 AM |
How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. | Jersey Girl | General Discussion | 1 | March 10th, 2005 04:20 AM |
Selecting Charts in a Macro | Herman Merman | Charts and Charting | 1 | August 18th, 2004 12:25 AM |
Is it possible to plot 3 surfaces in a Pivot Chart? (Repost) | Alison | Charts and Charting | 5 | October 21st, 2003 11:00 PM |