HELP with excel table/chart

  • Thread starter Thread starter lafleur82
  • Start date Start date
L

lafleur82

I have a question that I am almost sure has a very simple answer.
have a small table with 3 columns. The first column is density and ha
a set of values beneath the column heading. The second column is heigh
and has a set of values beneath the column heading as well. However
the is a second set of values in the third column that go with th
heading for the second column and need to correspond with the value
from the first column. I want to combine the values from the 2nd an
3rd columns so that I can make a scatter plot with one set of point
for height. here is an example

blah blah 2
1 2 3
1 2 3
1 2 3
1 2 3

I need to combine the 2s and 3s so that in a chart the values for bla
will be displayed on the x axis and the values for blah 2 will b
displayed on the y axis with one set of points for columns 2 and 3.

the spacing is messed up on the example but think of the #s as thre
separate columns with columns 1 and 2 corresponding with the first
headings
 
Make an XY chart using columns 1 and 2
Select columns 1 and 3 (select all of column 1 with mouse, hold down CTRL
key and select all of third column)
Use Copy (Edit|Copy or the Copy tool)
Click on chart to activate it
Use Edit|Paste Special and indicate New DATA (Not New SERIES) and that first
column has category value); click OK

done

best wishes
 
Have you tried a bubble chart? I never knew it existed until recently and
it may be useful for your application. It's one of the standard chart
types in EXCEL.
 
Back
Top