I need to create a 3D bar/cylinder chart where the bars are filled with Gradient based on the max height. Like the hign mountains where the peak is white and below you have shades of green. Gradient Fill on 3D Series only picks up the primary
color and never see the secondary.
Ideally, I'd specify the 'low' color (say black) and 'top' color (say white) and the bars will have the gradient from black to the % of grey that corresponds to their height ratio.
If the max value is 100, a bar of value 10 will start from 100% black to 90% grey. A bar of value 85, will start again from 100% black to 85% grey.
The data set is a matrix of X (number) ,Y (date) and Z (number) and could draw like a scatter plot but I have many similar high Z values in close proximity which hide themselves behind each other.
My aim is to be able to view the 3D chart from any angle and be able to see the peaks of same or similar heights.
Recommendations or alternatives?
View Complete Post