Absolute values formatted on chart axis scale

[cass108]

Hi

I'm charting a time series with both positive and negative values. I would like the y-scale to show only the absolute values, not the positive and negative values. The standard format, for example, would go from -10 to 10, but I would like both axis extremes to be 10, without displaying the negative symbol. Is there a custom format that will display only the absolute value of a number? Or another quick and dirty way to accomplish this?

Thanks

 

[Juan Pablo González]

Yep, format the y-axis as

0;0

or

0.00;0.00

if you want decimals

 

[cass108]

Great!! Thanks for the quick reply.

 

[amh38]

Yep, format the y-axis as

0;0

or

0.00;0.00

if you want decimals

Is there a list of the various formatting codes for excel? Something I can look at and build various examples of what you just provided above? E.g. something different than absolute value.

There are tons of specific ones on the web but I'm more looking for one where I can see what a semi colon would do, etc. So that I can build them whenever I want.

Thanks!