Graphing x,y weighted scatter plot (Excel 2007)

[SP33Demon]

Hey guys, probably a pretty quick question regarding a scatter plot. I have 3 columns: x, y, and the weighted value. I am trying to create a scatter plot incorporating the weighted value, does anybody know how to do this?

To get the regular scatter plot I am highlighting the x,y and just doing an Insert tab>Scatter with only Markers...

Thanks in advance!

 

[mpo]

Excel has a bubble chart that can show the weighted value of the third variable.

Highlight the three columns with the variables, go to the insert tab, then select 'other charts'. The bubble chart is near the bottom of the 'other charts' drop-down.

 

[Binky]

You could make a chart with two axis, one for X and Y, and one for the third variable. These are under custom, either 2 lines or line+column.