+ Reply to Thread
Results 1 to 2 of 2

3D Charting

  1. #1
    Registered User
    Join Date
    01-29-2007
    Posts
    92

    3D Charting

    Want to chart a variable with respect to two other variables. It's not exactly a surface plot. Most tutorials talk about surface plotting

    Example

    Z X Y
    40 205 460
    41 206 461
    42 207 462
    43 208 463
    44 209 464
    45 210 465
    46 211 466
    47 212 467

    Z goes up/down
    X goes left /right
    Y goes into/outof the page

    I want to make a 3 dimensional scatter plot of this data.

    Is it possible?

  2. #2
    Registered User
    Join Date
    04-07-2004
    Posts
    8

    Re: 3D Charting

    One way to do this is illustrated in the attached file, or you can download it from:
    www.xlrotor.com/3D_scatter_chart_in_Excel.xls
    There are no macros in the file.
    It uses a pair of defined names for formulas.

    I hope this helps.

    Brian in Austin, Texas
    Attached Files Attached Files

+ 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