I am trying to generate a contour plot from the data on a worksheet. There is no problem with the generation of the plot, but there is no way to select the color ranges for the contours. Excel does that on its own and it seems there is no way to specify the range of values for particular color on the contour plot. I have been trying to do this both with vba and the chart options, but I can't find a way to do it.
I have attached an example, please take a look and you will understand why I have been trying to do this. I will appreciate any help.