Project over time stacked bar chart
 

Greetings and thanks in advance for reading and/or answering.

I'm no more than a casual user of Excel so I don't get to tinker with
it as often as I like and I have to study and experiment to get the
charts that I need.

For my latest chart, I'm trying to figure how to use a horizontal
stacked bar chart to represent projected completion dates of projects
over time. But I'm struggling quite a bit on how to put it together.
My data would go something like this: Project A: Stage 1 - January,
Stage 2 - February, Stage 3 - June; Project B: Stage 1 - January,
Stage 2 - March, Stage 3 - May; Project B: Stage 1 - Febraruy, Stage 2
- March, Stage 3 - April.

I'm using the horizontal stacked bar chart to show that the projects
will transition from one stage to the next, so I'm firm on this type of
chart as the one I'll be using.

So if anyone has an idea on how I'd set those up, that would be
terrific, but meanwhile I'll struggle through it and review some of
these other threads. Again, thank you!


--
The WB
------------------------------------------------------------------------
The WB's Profile: http://www.officehelp.in/member.php?userid=5810
View this thread: http://www.officehelp.in/showthread.php?t=1313707

Posted from - http://www.officehelp.in

Project over time stacked bar chart
 

Hi,

Have a read of Jon's articles on gantt charts
http://pubs.logicalexpressions.com/P...cle.asp?ID=343
http://peltiertech.com/Excel/Charts/GanttChart.html

Cheers
Andy

The WB wrote:
Greetings and thanks in advance for reading and/or answering.

I'm no more than a casual user of Excel so I don't get to tinker with
it as often as I like and I have to study and experiment to get the
charts that I need.

For my latest chart, I'm trying to figure how to use a horizontal
stacked bar chart to represent projected completion dates of projects
over time. But I'm struggling quite a bit on how to put it together.
My data would go something like this: Project A: Stage 1 - January,
Stage 2 - February, Stage 3 - June; Project B: Stage 1 - January,
Stage 2 - March, Stage 3 - May; Project B: Stage 1 - Febraruy, Stage 2
- March, Stage 3 - April.

I'm using the horizontal stacked bar chart to show that the projects
will transition from one stage to the next, so I'm firm on this type of
chart as the one I'll be using.

So if anyone has an idea on how I'd set those up, that would be
terrific, but meanwhile I'll struggle through it and review some of
these other threads. Again, thank you!



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info