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

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

aaron

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.
 
B

Bernard Liengme

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
 
A

aaron

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

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

Data points in chart incorrect 0
x-y scatter plots and trend lines 0
Scatter PLotting using Data in third colum to determine range 2
different color for scatterplot with 1 series 5
Employee Schedule not plotting properly - chart type / data series not correct 0
adding trendline to plots from multiple series 1
Plotting Graph with dynamic table 3
Non Linear Scatter plot, need to find y value 3

Top