Create Status Chart for projects

[Urgent question regarding LIST]

Hello,
I need to create a status report for about 10 project that my group works
on. But we don't have any sort of measurement tool like budget or %
complete. All I have is the listing of projects and it's Green, Yellow or
Red. Is there any way to put them in bar or pie chart. Please I need this
for presentation. Any thoughts or ideas would be helpful

Thanks and Regards
Pooja

 

[Jon Peltier]

If you don't have any metric, why waste time trying to divine a chart out of
it. I see two choices:

Make three lists, for Good, Medium, and Bad.

Make one list, and use some kind of formatting or icon to indicate Good,
Medium, and Bad.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Urgent question regarding LIST"

 

[Matt Richardson]

If you don't have any metric, why waste time trying to divine a chart out of
it. I see two choices:

Make three lists, for Good, Medium, and Bad.

Make one list, and use some kind of formatting or icon to indicate Good,
Medium, and Bad.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

Another alternative, if you really want to use a chart would be to
create a table where you count the numbers of Green, Yellow and Red
projects. That way you can then make a simple chart which shows the
numbers.

List your data like this


Status Number
===============
Green 1
Yellow 4
Red 5

(obviously using numbers relevant to you).

Highlight the cells and press F11 (shortcut key for creating a
chart). Excel will then take your data and make a chart out of it.
It's that easy, and then you can just play around with customising
colours, headings etc etc.

Hope this helps,
Matt Richardson
http://teachr.blogspot.com

 

[Urgent question regarding LIST]

Hello Matt
Thanks for your response.
I need to present this presentation to the ED and MD and they like to see
the high level of info in charts more visual.....
I have total 10 projects, and 7of them are green and 2 of then yellow and 1
of the red. now we don't have any way to measure the project like budget/or
hours......

Wht i need is on the x axis I need to list the project names and on the Y
axis I want to list green, yellow, red.....and when the project is
green...it's charted against the greens status...and when project yellow or
red it's listd against the yellow or red status on the y axis....
I hope I was able to explain this clearly.....
I really appreciate your time....I need to present this by tuesday next
week.....

Thanks in advance...

Pooja

 

[Jon Peltier]

So you have project names along the horizontal axis, and some fit into each
of three colored categories. How do you want to indicate this? If you had a
metric, you could have colored bands for each color category, then the point
above the project name would be plotted within the band represented by its
metric.

Or do you just want to put a big colored dot, hovering above the project?
Have data like this:

Red Yellow Green
Project 1 1
Project 2 1
Project 3 1
Project 4 1
Project 5 1
Project 6 1
etc.

Make a line chart, format each series so it has no lines and large circular
markers (experiment to find an appropriate size) with the appropriate color.
Delete the vertical axis, since it's really meaningless.

I put the data into separate series above so you could change a color by
moving the "1" from one column to another.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Urgent question regarding LIST"