surface chart

  • Thread starter Thread starter judy
  • Start date Start date
J

judy

Will excel graph a real surface chart from data in 3
columns (x, y and z), so it's a perspective plot?
 
Ye

You have to arrange your data as a table with the x values across the top and the y values down the LH side, and fill in the Z values for each x, y pair. Then select the whole table and go into the surface chart otion. You can change the perspective, magnification, viewing angles etc in the dialog box

Happy charting!
 
Maybe. XL's 3D charting capability is rather limited. For more see
the Excel/Charts/3D Surface page of my web site.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top