cancel
Showing results for 
Search instead for 
Did you mean: 

Bar chart - different colour for negative

Former Member
0 Kudos

I'm displaying a bar chart in CR10. My client wants the negative values to be shown in a different colour, and I can't see how to do this. I could use 2 series I guess - one for above the line, and the other below - but I reckon that would look crappy.

Any ideas?

Andrew

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Andrew,

You can use 'Color Highlight' to color the series when the value is negative.

Right-click the chart and select Chart Expert > Color Highlight > In the 'Value of' drop-down select the series and put in the condition to be 'less than' zero.

Hope this helps!

-Abhilash

Former Member
0 Kudos

I can't see any reference to Color Highlight in the Chart Expert (or the help). Perhaps this isn't in CR10?

Andrew

abhilash_kumar
Active Contributor
0 Kudos

Hi Andrew,

I don't think there is a Highlight tab in Chart Expert for CR 10. The settings are located in the Format Chart option.

You would first need to uncheck the 'Automatically set chart options' box under the 'Type' tab of 'Chart Expert', then click 'Options' tab and click Format.

Hope this helps!

-Abhilash

Former Member
0 Kudos

Thanks, Abhilash. Got there eventually.

Andrew

Answers (0)