XY Scatter Plot

Topic

New Reply

Good Day To All,
I have multiple columns of numerical data in columns a, b, c,. The y values or column c range from 135 to 155, each of the two coulmns of “x” values
range from .09 to .35 for column a and for column b from .07 to .34. The scatter graph utilizing columns c with column b works fine, the one using
column c with a does not. The y and x axis scales in the good or correct plot range from 125-155 and 0.00 to 0.40 repsectively. In the bad plot the same
scales are 0-160 and 0-140 respectively. I have tried modifying the scales with no success. I noticed that when using the wizard for the bad plot, the
Source Data Data Range is blank, but the data series is filled in and correct. Any suggestions? When dealing with an Excel table with many columns of data, it is real difficult to designate which dat you wish to utilize for …in this case an XY Scatter Plot.

Many Thanks,
Marty

Reply | Quote

Replies

Can you upload a sample sheet displaying the correct and incorrect results?

Reply | Quote

Can you upload a sample sheet displaying the correct and incorrect results?

Hi,

attached is a copy of the excel file, shhet one is the source or original data, sheet 2 contains what I copied from sheet 1 to make it easier. Does excel allow charting of two non-adjacent colums of data? I think it may have something to do with whether or not there is text or a label in the top cell of each column.

thank you for your assistance.

regards,
Marty

Reply | Quote

Does excel allow charting of two non-adjacent colums of data? – Yes

How I did it (on sheet 1)

Highlighted the column for the X axis values – data only
Launch the chart wizard
choose the XY scatter
Next>
choose the Series tab
copy the range showing in the Y values
paste the range into the X values
change the Ss in the Y values to the column letter for your first Y value series (K or L in your sample book)
click into the Name box
highlight the cell you want to use as the name for the series
click the add button to add another series
paste the data you copied earlier into the X values and in the Y values boxes
change the Ss in the Y values to the column letter for your second Y value series (K or L in your sample book)
highlight the cell you want to use as the name for the series
finish the wizard as you normally would

See attached for the results.

Reply | Quote

Does excel allow charting of two non-adjacent colums of data? – Yes

How I did it (on sheet 1)

Highlighted the column for the X axis values – data only
Launch the chart wizard
choose the XY scatter
Next>
choose the Series tab
copy the range showing in the Y values
paste the range into the X values
change the Ss in the Y values to the column letter for your first Y value series (K or L in your sample book)
click into the Name box
highlight the cell you want to use as the name for the series
click the add button to add another series
paste the data you copied earlier into the X values and in the Y values boxes
change the Ss in the Y values to the column letter for your second Y value series (K or L in your sample book)
highlight the cell you want to use as the name for the series
finish the wizard as you normally would

See attached for the results.

Reply | Quote

Thanks again….lesson learned highlight only the numeric column data, add the title info later….this was a big epiphinay for me.

Reply | Quote