Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 online 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 is exactly what I would like to see. Chart describing data layout

share|improve this question
for the y values you ned to transform the red, green etc to a number for a line graph? What values do you choose? – Mark Apr 20 '11 at 15:28
Hmm, so its not possible to list the colour values, (red/green/yellow) on the Y axis, and have the line graph create a marker at red for x value 10/17/2001? – Chris Buckler Apr 20 '11 at 15:31
can you sketch the result you want on MS Paint or similar program just to see it? – kokbira Apr 20 '11 at 17:27
@kokbira I have edited my question to include a machup in mspaint. Thanks! – Chris Buckler Apr 20 '11 at 17:37
up vote 1 down vote accepted

I'm trying but I have "partial success"...

For THREE COLOR NAMES, you can do that:

audit date | blindness code
10/17/2001 | 2
10/17/2002 | 1
10/17/2003 | 3
10/17/2004 | 2
10/17/2005 | 3

Where 1 is for green, 2 is for red and 3 is for yellow.

Then format the "blindness code" cells to that custom format:


So, when you put it on XY graph, choose X for audit data (date format) and Y for blindness code (custom format) and your graph will show them as you want.

share|improve this answer
Tested with Excel 2003. Perhaps with other versions you can add more conditions in custom formats... I tested with Open Office 3.2 and it has the same limitations... – kokbira Apr 20 '11 at 18:52
Thanks kokbira! – Chris Buckler Apr 20 '11 at 21:53

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.