Creat 3D picture of box measurement

[coolhit]

Hi Please can anyone help

I want to create 2 X 3D diagram of a box by typing measurement of Box 1 verses Box 2

ie. i type in cell C3=width, C4=Depth & C5=Height measurment of BOX 1 and then H3=width, H4=Depth & H5=Height measurment of BOX 2.

Can someone please help how i do this.

[Domski]

I'm intrigued why you would want to do this?

Dom

[coolhit]

I'm intrigued why you would want to do this?

Dom

I want to do this because we order standard size box BUT when our supplier runs out off the boxes we get replacement boxes and to compare in our mind get bit difficult.

So i thought if we we can see visualy the boxes in 3d diagram dimision we can get feel for what it may look like.

[Andy Pope]

Rather than a 3d view how about a 2d view of the 3 planes.

This workbook will draw the 2 boxes so you can visualise the size variation.

[Domski]

Fair enough. This will insert a cube onto the active worksheet:

Please Login or Register  to view this content.

The first two numbers relate to the position and the latter two the size.

Dom

[riz4u]

great work