Results 1 to 5 of 5

Excel 2013 2D/3D Surface charts-editing band size?

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2011
    Location
    Australia
    MS-Off Ver
    Excel 2019
    Posts
    57

    Question Excel 2013 2D/3D Surface charts-editing band size?

    Hello

    I am actually using Excel to visualise 3D pointcloud data (x,y,z) of a surface by using Excel 2D/3D Surface charts.
    Creating the charts is quite easy, but I am having trouble trying to customise the way the chart looks.

    It is interesting to point out that visualising the 3D pointcloud data can be done without even using a chart in Excel. You simply dump your (x,y,z) data in to a table (x running horizontally, y running vertically and the z values filling the interior of the table), select all the z values and apply a Conditional Formatting Colour Scale to it. (I have discrete values of x and y which makes doing this possible).

    This is what my data looks like when I zoom out, essentially it is like a "heat map":

    2mdm1df.jpg

    Now taking this same data and creating a 2D Surface chart, the chart looks like this, which has a 3D shading type of effect which if good for visualising the troughs and valleys:

    vqo0t0.jpg

    The shaded 3D effect of the chart is very effective but the colour bands/bin sizes are quite coarse being 10 in size. I want to edit these to be 5 in size which will make visualisation of the data even more accurate. I can't work out how to change this. If I right click on the legend bands on the chart I get these options which don't help.

    2a7ev7k.jpg

    If I right click the chart and change the chart type to a 3D Surface plot, the chart now looks like this, and as you can see it defaults the colour band/bin size to 5.

    1rrs04.jpg

    If I right click on the vertical Z-axis on the chart I can edit the Axis options/Major Tick Size which in turn affects the colour band/bin size.

    \1

    2hxqcy8.jpg

    How do I get the same colour band control when using a 2D surface plot? Why would this functionality NOT be a feature of 2D Surface plots which in theory you think are "easier" to process?

    PS: I have tried rotating the 3D Surface plot to try to "look straight down" on it but after around 60 degrees of rotation the chart automatically changes to the 2D Surface chart I originally started with.
    Last edited by I-Like-Excel; 09-24-2015 at 07:49 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel surface charts
    By Mutak in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 05-30-2015, 01:30 PM
  2. VBA Excel 2013 - Count data rows on single sheet, divide by 3 , color band rows.
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2015, 01:33 PM
  3. Pull excel 2013 DB records into a userform for editing, and re-submitting
    By bigfatpies in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2014, 04:11 PM
  4. EXCEL 2013 - opening read only files and editing them
    By sca1079 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2014, 09:03 PM
  5. Multiple Surface Charts
    By np123345 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-02-2011, 03:45 PM
  6. surface in radar charts in Excel
    By elka in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-10-2006, 07:53 AM
  7. Can Excel calculate area for 3-D surface charts?
    By RAH in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-20-2005, 12:06 AM

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