If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Newbie needs help with first scatter plot
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 |
#2
|
|||
|
|||
Newbie needs help with first scatter plot
On Oct 30, 11:43 pm, wrote:
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 |
Thread Tools | |
Display Modes | |
|
|