Projects and Stage Chart

M

Marie

Hi,

How would I create a chart that has the projects(names) and the different
stages the projects are at, like delivery date, assemble products, agreement,
etc. I tried creating a Gantt chart but I don't have the dates for the
projects. The data that I have are just 2 columns: Projects and Stage. I have
11 projects and 14 stages. E.G.: for project 1 - the stage that corresponds
to it might be "report". I just need to know what stage the projects are at
and update with another stage in the future.What type of chart would I use?
How would I do that?

Thank you,

Marie
 
S

Shane Devenshire

Hi,

Suppose that A1:A10 contains your project names and in the Stage column, say
B1:B10, you use number to indicate the 14 stages - enter 1 to 14 as
appropriate for each project.
The choose A1:B10 and plot a cluster Bar chart.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Burn-down chart 4
Multiple Bar Chart Formats 1
Trying to add resource allocation data to a gantt chart built in E 0
Special Request 3
How to create a bubble chart with more than 2 variables 0
Creating a Report with Mulitple Headers 2
Difficult chart to compose? 3

Top