TEXT STATUS -VS- Numbers

DDBeards · Aug 9, 2005

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

Jon Peltier · Aug 15, 2005

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/
_______