I would like the dates to appear on the X-axis and the colour category to apear on the Y-axis, Excel

there is probably a fairly straight forward answer out there but I can not seem to find a solution online.

I have a table marked up like this (column names are in bold)

audit date | blindness

10/17/2001 | red

10/17/2002 | green

10/17/2003 | yellow

10/17/2004 | unknown

10/17/2005 | red

I would simply like to make a line graph in excel, where the audit date values are the X-axis categories, and the blindness values are the Y-axis categories.

I have tried so many little tutorial's onl开发者_开发技巧ine but my graph never comes out looking correctly. I can not get the axis the way I'd like.

PS - I am using Excel 2003

This will tell you how to do it:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

P.S. I'm colorblind :-)