View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Create Status Chart for projects

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"
.com wrote in message
...
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