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