•  
  •  
 

Abstract

A method of graphing functions of two variables in spreadsheets is presented. The method uses parallel orthogonal projection. The xyz coordinate system is revolvable in two planes so the graph can be viewed from any direction. The graph is constructed as a mesh made over the rectangle [xmin, xmax] x [ymin, ymax] in the x and y directions. Graphing discontinuous functions are also shown. The visibility problem, that is, the problem of overlapping, is not solved.

Graph f(x,y) D=R.xls (308 kB)
Application for graphing z = f(x,y) if D(f) = R

Graph f(x,y) DnotR.xls (2196 kB)
Application for graphing z = f(x,y) if D(f) <> R

Graph f(x,y) D=R.xlsm (243 kB)
Application 1 in MS Excel 2007

Graph f(x,y) DnotR.xlsm (1552 kB)
Application 2 in MS Excel 2007

Share

COinS