surface chart

  1. R

    Surface Chart In VBA 2013

    S0 ive been looking online for various example on how to make a surface chart in vba by taking values in one worksheet and displaying it in another but havent really found anything to help. The code I used(which I will display below) displayed the chart but in the increments in the axis were...
  2. C

    Showing grid lines on the surface of a Surface Chart?

    I've dug through the chart options, but didn't find a way to show the major grid lines on the Surface Chart itself. Anyone know how to do this? THX Chad
  3. R

    Charting color map

    Ok, so this has probably been posted before, but I can't find it on any google searches because I'm not entirely sure what you would call it... I need the end user to see a chart of at least 400,000 values (1000x400) simultaneously (and potentially 4M :eek:). This has perplexed me for quite...
  4. S

    surface charts: changing legend color of values above/below range

    Hi All, I'm working with surface charts for the first time. I've set my legend color range for the z-axis to something that does not include all values in the data (eg, data is 0-40, but i want a 0-30 range displayed), but this leaves me without the ability to change the color for areas...
  5. I

    contour (surface) chart and gradient series colors

    OK, complicated question. I'm trying to create a contour plot (one of the 2D surface charts) that shows a gradient of colors in the plot. As in, I want 100 different colors used in the plot area. BUT... I only want 10 basic colors shown in the legend as a reference. I got the 10 colors in the...
  6. S

    Using color as a 4th variable in surface charts

    I am wondering if it is possible to use color as a 4th variable in surface charts. I have a standard 3-dimensional surface chart, with x, y, and z values. Further, for each (x,y) value I have a 4th dimension (call it u), ranging from 0 to 1. I would love to be able to set the color (or...
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

This Week's Hot Topics

  • link pictures from Sharepoint to Excel macro
    Hi, I need your help to fix this issue. I have a code and this is work on my computer. But now I try to link the picture from the SharePoint to...
  • lookup match return closest to x date
    Hi all, Happy New Year, this is my first post in 2022. I have two worksheets I'm working with. worksheet one is titled KPI Data - MY22 ONLY It...
  • Average hours per week
    I'm trying to find a simpler/quicker way to obtain the average number of hours per week for employees. My spreadsheet contains columns for Date...
  • Google Sheets IMAGE Function
    Is there any way to replicate the IMAGE function from Google Sheets in Excel? Maybe a VBA code? From what I can tell, the function in Google...
  • Identify equipment used -No of consecutive days
    Hello, I appreciate your time and effort. I would like to have formula for column O and P. Column A : lots of Asset Column C: date If one Asset...
  • Filling in data from source
    Hi All, I'm not quite sure what to call the following type of data manipulation so I don't quite know how to phrase my question. Below is an...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top