| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I automatically plot different ranges of data in different.
I need to chart parameters that are a function of three variables in the 2002
version of Excel. I have used the x and y axis to represent 2 variables on an 'xy chart', but require an automatic method to represent the value of the third variable. I have tried the 'bubble-plot', but cannot get sufficient resolution between the data. Is their any way that I may plot the third variable in different colours/shades, that automatically changes for different ranges of the the third variable? |
|
#2
|
|||
|
|||
|
THis might help you:
http://www.peltiertech.com/Excel/Cha...html#CondChart "3D-charting" wrote in message ... I need to chart parameters that are a function of three variables in the 2002 version of Excel. I have used the x and y axis to represent 2 variables on an 'xy chart', but require an automatic method to represent the value of the third variable. I have tried the 'bubble-plot', but cannot get sufficient resolution between the data. Is their any way that I may plot the third variable in different colours/shades, that automatically changes for different ranges of the the third variable? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I plot Excel data on a floorplan? | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
| getting data from 2 excel sheets automatically | Excel Worksheet Functions | |||
Linear Mode
