Thread: Graph with text
View Single Post
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

You need to convert the status to a numerical scale (1,2,3,4), plot
X=project vs Y=numerical status, and finally fix up the vertical axis:

http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

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


DDBeards wrote:

I have a status field "Open, Working, On-Hold, or Done" and a second column
for project name. I want to create a chart that shows the project name on
the x-axis and the status on the Y axis. THIS IS A SECOND REQUEST, please
help.

DDBeards