Thread: TEXT STATUS -VS- Numbers

We have name of projects with 8 different status. We want to create a chart
with the name of the project on the X axis and text status on the Y axis.
Can this be done and if so how. Please help

DDBeards

If you assign numbers 1-8 for each status, you can then hide the 1-8
axis labels, and add custom ones:

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:

> We have name of projects with 8 different status. We want to create a chart
> with the name of the project on the X axis and text status on the Y axis.
> Can this be done and if so how. Please help
>
> DDBeards