Wrong colors in Colorgrid
Posted: Thu Jul 06, 2006 10:51 am
Hi,
after Narcis helped me to get the z-values of my colorgrid the next problem became visible.
I defined custom colors for the colorgrid --> see below:
But the colors are now displayed accordingly.
So for a value of 1 it displays the color for value > 2
I have no clue. Please help.
Kind regards,
Jan
after Narcis helped me to get the z-values of my colorgrid the next problem became visible.
I defined custom colors for the colorgrid --> see below:
Code: Select all
With .Series(1)
With .asColorGrid
.AddPalette -3, &H0
.UseColorRange = False
.UsePalette = True
.ClearPalette
.AddPalette -3, RGB(204, 0, 0)
.AddPalette -2.75, RGB(221, 0, 0)
.AddPalette -2.5, RGB(238, 0, 0)
.AddPalette -2.25, RGB(255, 0, 0)
.AddPalette -2, RGB(255, 68, 0)
.AddPalette -1.75, RGB(255, 102, 0)
.AddPalette -1.5, RGB(255, 136, 0)
.AddPalette -1.25, RGB(255, 170, 0)
.AddPalette -1, RGB(255, 204, 0)
.AddPalette -0.75, RGB(255, 238, 0)
.AddPalette -0.5, RGB(255, 255, 68)
.AddPalette -0.25, RGB(255, 255, 187)
.AddPalette 0, RGB(255, 255, 255)
.AddPalette 0.25, RGB(153, 255, 153)
.AddPalette 0.5, RGB(85, 255, 85)
.AddPalette 0.75, RGB(34, 255, 34)
.AddPalette 1, RGB(0, 238, 0)
.AddPalette 1.25, RGB(0, 204, 0)
.AddPalette 1.5, RGB(0, 170, 0)
.AddPalette 1.75, RGB(0, 136, 0)
.AddPalette 2, RGB(0, 0, 204)
.AddPalette 2.25, RGB(0, 0, 170)
.AddPalette 2.5, RGB(0, 0, 136)
.AddPalette 2.75, RGB(0, 0, 102)
.AddPalette 3, RGB(0, 0, 68)
.IrregularGrid = True
End With
End With
So for a value of 1 it displays the color for value > 2
I have no clue. Please help.
Kind regards,
Jan