How can i create a scatterplot with small and medium values?

[casa3819]

i am trying to find a correlation between donating members and emloyees in
organisations. The firms have classsed them selves as either small or medium
and i would like to plot this information in a scatterplot. the legends would
be small and medium and the x, y members and employees.
Can anyone help with this matter?
Thanks

[B. R.Ramachandran]

Hi,

Sort out you data by the column containing the firm classification. By
doing so the the data is rearranged into the "small" and "medium" blocks.
Plot the data for the small and medium firms as two separate data series in
the same XY-scatter plot.
You can now name the legend for each plot as you wish (e.g., "small" and
"medium").

If you want the original data arrangement to be in tact, you could copy the
entire data onto another sheet for sorting and plotting .

Regards,
B. R. Ramachandran

"casa3819" wrote:

> i am trying to find a correlation between donating members and emloyees in
> organisations. The firms have classsed them selves as either small or medium
> and i would like to plot this information in a scatterplot. the legends would
> be small and medium and the x, y members and employees.
> Can anyone help with this matter?
> Thanks

[casa3819]

it was quite useful thanks, in the end, i had to just plonk the information
into a table. Thank you for your help.


"B. R.Ramachandran" wrote:

> Hi,
>
> Sort out you data by the column containing the firm classification. By
> doing so the the data is rearranged into the "small" and "medium" blocks.
> Plot the data for the small and medium firms as two separate data series in
> the same XY-scatter plot.
> You can now name the legend for each plot as you wish (e.g., "small" and
> "medium").
>
> If you want the original data arrangement to be in tact, you could copy the
> entire data onto another sheet for sorting and plotting .
>
> Regards,
> B. R. Ramachandran
>
> "casa3819" wrote:
>
> > i am trying to find a correlation between donating members and emloyees in
> > organisations. The firms have classsed them selves as either small or medium
> > and i would like to plot this information in a scatterplot. the legends would
> > be small and medium and the x, y members and employees.
> > Can anyone help with this matter?
> > Thanks