Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can i create a scatterplot with small and medium values?
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can i create a scatterplot with small and medium values?
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can i create a scatterplot with small and medium values?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|