Surface plots and grid removal 1

[corus]

Using surface plot to create a 2D contour from a rectangular grid of data, I find that even though no grid lines are specified, the chart includes a grid, or black outline, for each cell of data. How do you remove the black outlines so as to leave just continuous colour?

corus

 

[electricpete]

I was going to suggest the obvious:
right-click / chart options / Gridlines tab - uncheck everything.

But I tried it and it doesn't work. Hmmm.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[electricpete]

There is a way. It's just one of those weird excel things:

http://j-walk.com/ss/excel/tips/tip102.htm

In order to get the vba procedure to work on my chart, I had to comment out the line
If ActiveChart.ChartType <> xlSurface Then Exit Sub

I found out my chart was type 85. xlsurface is type 83. The code worked fine once that line was removed.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[corus]

Brilliant! And an excellent web site for tips.

corus