Hi,

I have created a Horizontal Bar Chart with a color Palette of Blue with 8 Stepped Color.

I have changed the chart to Logarithmic to view rows with small amounts.

Besides, manually updating the End range of the color Palette, is there an automated way for the Total Bar not to be included in the Palette color calc, hence always be the darkest color without affecting other bars?

Cheers,

David