Scatter plot in Excel

[Ned Bedinger]

Dan Garza wrote:
> Help my client wants a scatter plot in Excel
>
> The data is really strange to make a graph out of 
>
> Y axis is time, now, 6-12months, When available, never
>
> X axis is preference, represented by numbers, I won't go into details about
> that, but I was able to get them to convert the letters to numbers. 0 =
> forget it and 15 = absolutely.
>
> Now there are 20 services that were surveyed, so there will be 20 charts
> upon my urging.
>
> Now how do you make the dots larger in Excel? If its 15 then it should be a
> big dot, if its 0 then a tiny dot.
>   
Can't help you with the dot size, but if you don't mind my asking, why 
use different sized-dots? Is this an abstract style of scatterplot that 
doesn't show the scale of the axes? How will your plot show time if the 
axes aren't labeled?