View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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.