XY Scatter + Bubble?

  • Thread starter Thread starter PJD
  • Start date Start date
P

PJD

I have an XY Scatter chart and I want to make the data
points reflective of their relative size based on a third
quality. For example, I have the number of units on one
axis, and the selling price on another. I would like the
data points to reflect the % of associated defects by
becoming relatively larger or smaller than the other (like
a bubble graph).

Any ideas? TIA!
 
Hi PJD,

That would be a bubble chart then ;)

Excel has this as a built-in chart type, as of version XL97 I think.
The chart requires 3 pieces of information X,Y,Size.

Or have I missed something in your question?
I have an XY Scatter chart and I want to make the data
points reflective of their relative size based on a third
quality. For example, I have the number of units on one
axis, and the selling price on another. I would like the
data points to reflect the % of associated defects by
becoming relatively larger or smaller than the other (like
a bubble graph).

Any ideas? TIA!
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top