Basic 3D-2D (Perspective) Visualization

The first two worksheets of this Excel workbook illustrate the creation and display of a rectangle by using a 2D scatter plot. They also show how to adjust its size, translate and rotate it.

In the third worksheet a wire-frame cube is created. 3D-2D perspective calculations are done. The cube can be zoomed and it can also be rotated in azimuth and altitude using simple macros.



  1. Author

    Gracias Caballero!

  2. Hola George Lungu, muchas felicidades por tu trabajo, es muy creativo y maravilloso.

  3. Author

    Albert, the method applies to any problem if you are content to plot wire frame surfaces only (no texture or opacity, just a skeleton surface). What kind of surface are you trying to plot?

  4. Hi Javier,
    I am try to plot 3D curves (with x, y z data) in excel using ur method but it seems they doesnt work well.
    Does ur method only applicable to my problem?

    Thank you,

  5. I am linking to this blog post and using your demo as a reference. If you would like me to remove the link please message me back and let me know.

    Great post by the way!

  6. George,
    Do you have an updated version of this that works on Excel2010? I have enabled the macros but none of the buttons work.
    Also, do you have a link to the theory that would tell me what alpha, beta, A & B are in the equations?


  7. hi George!

    mi trabajo tiene similitudes al tuyo, en el sentido de los objetos que se encuentran atrás o adelante

    Saludos! Vorwärts!

    Congratulations for you Blog!

Leave a Reply

Your email address will not be published.