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? Many thanks

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? Many thanks Hi yannisps, Gradients property is only suit for 2D chart, so I wound recommend you alter to 2D, then the report will have a gradually varied color from primary color to secondary color. Here , you could also submit a feedback to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback to get an official confirmation, the next release product might conclude this feature. Regards, Challen Fu