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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

surface chart 1
Surface Chart/Contour Chart options 4
x-y-z surface charts 1
scales on surface / contour charts 1
"circular" concentric charts - like a pilot's plotting/nav computer 1
Odd chart type needed 2
How do I make a 3-dimensional plot in Excel? 5
Excel charts 2

Back
Top