Surface plots and grid removal
Surface plots and grid removal
(OP)
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





RE: Surface plots and grid removal
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.
RE: Surface plots and grid removal
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.
RE: Surface plots and grid removal
corus