+ Reply to Thread
Results 1 to 2 of 2

3d Surface Plot with Axis to Scale

  1. #1
    Registered User
    Join Date
    06-11-2015
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    1

    3d Surface Plot with Axis to Scale

    Hi all,

    I am currently generating a 3d surface plot with VBA. I have an x-axis that consists of dates that are not evenly spaced out (ie June 24, June 29, July 17, etc.). I am wondering if it is possible to scale this axis for a 3d surface plot.

    I recall that an issue like this existed with line graphs. The data points would not be formatted to consider that the data points should be distributed according to date. Rather, the data points would be placed equidistantly, even though x-axis values would be (1, 3, 5, 10, 13, 15, etc.). This is solved by using the scatter plot IIRC.

    Is there a similar functionality with 3d surface plots?

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

    Re: 3d Surface Plot with Axis to Scale

    Not in Excel. Excel does not natively support 3D scatter plots. The X and Y axes of an Excel surface plot are only category axes, and cannot be value axes.

    The easiest approach might be to find another graphing package that specifically supports 3D scatter and surface plots.

    If you feel that you must do this in Excel, I would probably suggest that you start with Andy Pope's example and tutorial of 3D scatter plots in Excel: http://andypope.info/charts/3drotate.htm
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change plot axis units on logarithmic scale
    By energizek in forum Excel General
    Replies: 2
    Last Post: 09-30-2014, 01:52 PM
  2. Time series plot on scale on x axis
    By Ramansidhu71 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 06-18-2014, 01:59 PM
  3. [SOLVED] X axis scale on an XY scatter plot
    By Tim in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-21-2006, 08:55 AM
  4. CAD surface from EXCEL surface plot
    By tombemis in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-12-2005, 05:43 PM
  5. Creating XY Scatter plot with date-scale X-axis?
    By anon4you in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-12-2005, 03:19 PM

Tags for this Thread

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