user defined scale for surface plots
Is it possible to set a z-axis scale with intervals of non-linear magnitude
in surface plots? For example, I have data that ranges for 200-9000 in the z-scale. Defining the scale to some equal magnitude interval (like 1000) gives me (for example) 0-1000; 1000-2000; 2000-3000; etc. I am only interested in the upper end of the data rangefor this particular surface plot and would prefer to see the scale non-linearly, i.e. 8100-8910; 8910-8990; and 8990-9000. |
user defined scale for surface plots
My usual tricks for jobbing an axis require hiding the axis and using an XY
series to draw a fake axis with a transformed scale, matching a transformation applied to the data: http://peltiertech.com/Excel/Charts/...tml#AxisScales Surface charts and other charts with real or imaginary 3D effects do not allow combination with other chart types, so you can't use an XY series for this. I suppose you could go through the tedium of adding lines for tick marks and text boxes for tick labels, but that doesn't sound very entertaining to me. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Nels A" <Nels wrote in message ... Is it possible to set a z-axis scale with intervals of non-linear magnitude in surface plots? For example, I have data that ranges for 200-9000 in the z-scale. Defining the scale to some equal magnitude interval (like 1000) gives me (for example) 0-1000; 1000-2000; 2000-3000; etc. I am only interested in the upper end of the data rangefor this particular surface plot and would prefer to see the scale non-linearly, i.e. 8100-8910; 8910-8990; and 8990-9000. |
user defined scale for surface plots
Hi Jon,
But it is worse than that for a surface plot Z axis, as that is the one that controls the colouration. You can not specify non linear increments. You might be able to specify small increments and format all those point covering the range with the same colour. But you legend will look silly. Cheers Andy Jon Peltier wrote: My usual tricks for jobbing an axis require hiding the axis and using an XY series to draw a fake axis with a transformed scale, matching a transformation applied to the data: http://peltiertech.com/Excel/Charts/...tml#AxisScales Surface charts and other charts with real or imaginary 3D effects do not allow combination with other chart types, so you can't use an XY series for this. I suppose you could go through the tedium of adding lines for tick marks and text boxes for tick labels, but that doesn't sound very entertaining to me. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Nels A" <Nels wrote in message ... Is it possible to set a z-axis scale with intervals of non-linear magnitude in surface plots? For example, I have data that ranges for 200-9000 in the z-scale. Defining the scale to some equal magnitude interval (like 1000) gives me (for example) 0-1000; 1000-2000; 2000-3000; etc. I am only interested in the upper end of the data rangefor this particular surface plot and would prefer to see the scale non-linearly, i.e. 8100-8910; 8910-8990; and 8990-9000. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 08:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com