how can i color points in a plot with a third data series?

  • Thread starter Thread starter aaron
  • Start date Start date
A

aaron

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?
 
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.
 
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
 
thanks for your time. i could not see any mention of it in the online help
pages, but wanted to be sure.
 
Back
Top