Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I graph text information in Excel | Charts and Charting in Excel | |||
Text is disappearing when I try to print a graph | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Problem with graph ranges | Charts and Charting in Excel |