Newbie needs help with first scatter plot

[rcoutts]

I have a query with two fields: a date and a list of repeating words.
Something like

1/1/2007 Red
1/3/2007 Green
2/9/2007 Blue
3/1/2007 Red
3/3/2007 Blue

I want to create a simple scatter plot with Date on the X-axis and
Color on the Y-axis (there's only seven possible values for the words,
so I'd like each word on the Y-axis and a dot in the plot above each
date where it occurs). When I use the Chart wizard and select Scatter
Plot, the wizard is generating charts that plot *counts*, rather than
showing a single dot for each time it occurs.

I thought what I wanted to do was pretty straight forward, but now I'm
concerned it's not covered by a wizard and I don't have any experience
with charts. Is there a quick and dirty way to get what I need?

Thanks,
Rich

 

[rcoutts]

I have a query with two fields: a date and a list of repeating words.
Something like

1/1/2007 Red
1/3/2007 Green
2/9/2007 Blue
3/1/2007 Red
3/3/2007 Blue

I want to create a simple scatter plot with Date on the X-axis and
Color on the Y-axis (there's only seven possible values for the words,
so I'd like each word on the Y-axis and a dot in the plot above each
date where it occurs). When I use the Chart wizard and select Scatter
Plot, the wizard is generating charts that plot *counts*, rather than
showing a single dot for each time it occurs.

I thought what I wanted to do was pretty straight forward, but now I'm
concerned it's not covered by a wizard and I don't have any experience
with charts. Is there a quick and dirty way to get what I need?

Thanks,
Rich

Scratch that. I realized the plot I described is not what I'm after.
My apologies.

Rich