+ Reply to Thread
Results 1 to 4 of 4

3D XY scatter chart (x,y,z axis)?

  1. #1
    Registered User
    Join Date
    05-01-2012
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    85

    3D XY scatter chart (x,y,z axis)?

    Hello!

    Does anybody here know if it's possible to create a XY-chart in three dimensions - with a third axis in addition to the x and y-axis?

  2. #2
    Registered User
    Join Date
    10-01-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: 3D XY scatter chart (x,y,z axis)?

    Hi Hope this chart will help you.

    X axis shows the sales, y axis shows profit .. And the bubble shows the quantity.

    Fred
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-01-2012
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    85

    Re: 3D XY scatter chart (x,y,z axis)?

    Well I would definitely prefer to have the 3rd axis as well... But besides from that I cannot see how you created the chart - there is no data what so ever?

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: 3D XY scatter chart (x,y,z axis)?

    Excel does not have the ability to plot a true 3D scatter plot. If you can modify your X and Y data so they are evenly spaced (so they can be treated as 'categories'), then you can fake a 3D scatter plot. As Fred suggested, a bubble chart can be used to show 3D data. A contour plot (Z vs. X at different, constant values of Y) is also a good way to show 3 dimensions when only 2 are available. If you really must have a true 3D scatter plot though, you will need to look outside Excel.

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: 3D XY scatter chart (x,y,z axis)?

    You can compute 3d to the 2d points to get a version of a xyz plot in excel
    http://www.andypope.info/charts/3drotate.htm
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1