ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I automatically plot different ranges of data in different. (https://www.excelbanter.com/charts-charting-excel/11110-how-do-i-automatically-plot-different-ranges-data-different.html)

3D-charting

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?

Barb Reinhardt

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?





All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com