thanks for your time. i could not see any mention of it in the online help
pages, but wanted to be sure.

"Bernard Liengme" wrote:

Sorry, I thought you needed an intro to charting.
You want to use column 3's data to change the colour of points plotted from
column 2?
That would take some fancy VBA ; may I suggest you post the question in the
Excel.Programming newsgroup?

It would help if you included some sample data (especially the values in the
third column)
But on Jon's site you will find how to make conditional charts - different
coloured point for different value ranges

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"aaron" wrote in message
...
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?