Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Including a third variable in a point diagram by color-coding
I have a dataset with three variables x, y and z (They are not necessarily
functions of each other) Is it possible to crossplot x and y in a point diagram and additionaly indicate z by a color code? (I would then need to have an explaining color bar or something showing the range of colors and the corresponding values) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Including a third variable in a point diagram by color-coding
One way to do this is using a conditional chart. Generate as many columns of
calculations as you have colors you want to use: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Celia" wrote in message ... I have a dataset with three variables x, y and z (They are not necessarily functions of each other) Is it possible to crossplot x and y in a point diagram and additionaly indicate z by a color code? (I would then need to have an explaining color bar or something showing the range of colors and the corresponding values) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
color coding | Excel Discussion (Misc queries) | |||
Data point labels in a scatter diagram | Charts and Charting in Excel | |||
Color Coding Cells | Excel Worksheet Functions | |||
color coding | Excel Worksheet Functions | |||
Color coding | Excel Discussion (Misc queries) |