Select the More Colors option to show the Palette option.

For column/bar/histogram/area/ribbon/wall/waterfall plot, add checkbox By Y Value after gradient fill, enable when gradient fill is not none. For 3D Bar, the label could be By Z Value.