Thread: Graph with text

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

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