+ Reply to Thread
Results 1 to 3 of 3

3-D Surface Chart - Is it possible to have not equal bounds?

  1. #1
    Registered User
    Join Date
    09-03-2015
    Location
    Yorkshire
    MS-Off Ver
    2016 32bit
    Posts
    43

    3-D Surface Chart - Is it possible to have not equal bounds?

    Hi,

    Is it possible to not have equal bounds on a 3-D Surface Chart?

    My example, and desired bounds, attached.

    Cheers!
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: 3-D Surface Chart - Is it possible to have not equal bounds?

    3D charts are severely limited in Excel. How about just CF color scales?

    C
    D
    E
    F
    G
    5
    #
    0 mm
    250 mm
    500 mm
    750 mm
    6
    1
    256.1
    11.1
    6.9
    5.1
    7
    2
    268.6
    20.5
    9.9
    5.9
    8
    3
    235.5
    32.0
    11.2
    6.3
    9
    4
    181.9
    38.4
    12.9
    6.4
    10
    5
    142.9
    44.3
    18.3
    7.5
    11
    6
    130.2
    34.8
    19.0
    7.8
    12
    7
    109.5
    31.0
    18.2
    8.4
    13
    8
    103.7
    35.9
    13.1
    8.2
    14
    9
    96.6
    31.5
    11.2
    6.9
    Last edited by shg; 07-16-2018 at 12:47 PM.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: 3-D Surface Chart - Is it possible to have not equal bounds?

    Or you could use 6 conditional formatting rules to set the cell colors

    Value <= 0.2, some format, stop if true
    Value <= 15, some format, stop if true
    Value <= 40, some format, stop if true
    Value <= 75, some format, stop if true
    Value <= 150, some format, stop if true
    Value <= 250, some format, stop if true

    Then apply a default color to cover the case > 250

+ 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. [SOLVED] Excel Bubble Chart with Upper & Lower bounds
    By tranhaithang in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-10-2014, 09:00 PM
  2. Excel 2007 : surface chart - more colors
    By aaaa13 in forum Excel General
    Replies: 0
    Last Post: 05-04-2010, 12:10 PM
  3. surface chart
    By crazybass in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 03-03-2009, 07:47 PM
  4. Help with surface chart - its for a good cause...
    By lubell in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-21-2006, 08:13 AM
  5. [SOLVED] not able to get series value for 3d-surface chart
    By Lokesh Sharma in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-04-2005, 11:35 PM
  6. [SOLVED] surface chart problems
    By John in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-20-2005, 07:05 PM
  7. [SOLVED] Surface Chart Help
    By Alan Smith in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-28-2005, 05:05 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