Hi,

You just need additional series and formula to control the values for
those series based on original data and conditional test.

See Jon's examples
http://peltiertech.com/Excel/Charts/...nalChart1.html

Cheers
Andy

aaron wrote:
do you know the answer to my question? can i use a third data series to
scale the color of points on a scatter plot?

thanks for your time.

"Bernard Liengme" wrote:


You may wish to visit Jon's site
http://peltiertech.com/Excel/ChartsHowTo/index.html
to get more familiar with Excel cahrting.
Then come back and get any extra help needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"aaron" wrote in message
...

i have 3 columns of data, i would like one as x, one as y, and one as the
color of the points. is this possible?




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info