XY Scatter + Bubble?

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!
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XY Scatter with Column Chart 3
XY Scatter Chart Not Showing X Axis 1
Bubble Chart best fit Scatter plot 3
How do I adjust marker spacing in Excel scatter plot? 1
problem with scatter diagram excel 2007 2
xy scatter - dates off 4
XY Scatter Chart Markers 3
XY Scatter Plot Chart - URGENT HELP 1

Top