ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I plot a line chart in 3 dimensions (x,y,z)? (https://www.excelbanter.com/charts-charting-excel/113386-how-do-i-plot-line-chart-3-dimensions-x-y-z.html)

Kevinofromuk

How do I plot a line chart in 3 dimensions (x,y,z)?
 
Hello All, I wish to plot a scatter graph in Excel and join the points with a
smooth line. However I wish to do it using three variables (x,y and z axes)
as opposed to the simple 2D x and y axes I can easily use on excel?? Is
there a way to do this in excel??

Yours Hopefully,

Kev.

Andy Pope

How do I plot a line chart in 3 dimensions (x,y,z)?
 
Hi,

You can fake it using trig.
http://www.andypope.info/charts/3drotate.htm

Cheers
Andy

Kevinofromuk wrote:
Hello All, I wish to plot a scatter graph in Excel and join the points with a
smooth line. However I wish to do it using three variables (x,y and z axes)
as opposed to the simple 2D x and y axes I can easily use on excel?? Is
there a way to do this in excel??

Yours Hopefully,

Kev.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 12:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com