3D excel chart

[Tim]

As explained by Andy Pope I did a 3D excel chart and everything is OK. It is
representing a 3D line to be more precise.

I just want to go a step further and find a way to automatically adjust the
minimum and maximum axis/cage data values to those which will be actually
plotted.

Is any way to do this?

For example: I have data plotted those x,y,z values can be 500 or 5000. And
since my cage/axis data is predefined to a fixed value (to accommodate bigger
data), small data doesn’t look good in plot.

TIA

TIm

 

[Andy Pope]

Hi Tim,

You can use MIN and MAX formula to determine the values of the cage and
axis.
But to apply the values to the chart you will either have to do this
manually or use VBA code.
You can record a macro whilst you change the values and then substitute
range references instead of static values.

Cheers
Andy