| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 ... 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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 ... 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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i plot every 10 of my data points (i.e. 1, 11,21,.,10001) | Excel Discussion (Misc queries) | |||
| Change color of individual hiloline points in a series | Charts and Charting in Excel | |||
| How do you plot data points on a state map? | Charts and Charting in Excel | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
| Plot points with same x-value in same series? | Charts and Charting in Excel | |||
Linear Mode
