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 above/below what I've set. I can change the colors within the range, of course, but I can't find any place to change the color it assigns to anything outside the range. Anyone know if this is possible? I'm using Excel 2003.
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 above/below what I've set. I can change the colors within the range, of course, but I can't find any place to change the color it assigns to anything outside the range. Anyone know if this is possible? I'm using Excel 2003.