Y-axis lable formatting problem

Hi,

Please check the attachment.On chart i colud not able format labels.

Y-axis on right side should have currency formatting (negative numbers should be in red and parenthesis).

Thanks,

Arun

Please format column C same as column D. Then you will get your expected format. Please check the attached file.

Hi,

I am formatting C same as D column,but C may not have negative values like D.Whenever value is negative i am formatting value in red color.

Thanks,

Arun

Y-axis labels’ format is same as the source data. So to make it as your wish, please format source data.