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 |
All times are GMT +1. The time now is 12:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com