If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how can i color points in a plot with a third data series?
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? |
#2
|
|||
|
|||
how can i color points in a plot with a third data series?
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? |
#3
|
|||
|
|||
how can i color points in a plot with a third data series?
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? |
#4
|
|||
|
|||
how can i color points in a plot with a third data series?
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 news 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? |
#5
|
|||
|
|||
how can i color points in a plot with a third data series?
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 news 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? |
#6
|
|||
|
|||
how can i color points in a plot with a third data series?
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 |
Thread Tools | |
Display Modes | |
|
|