I used to be able to make negative values show without the minus sign in previous versions of PowerPoint (2003 and older), but 2010 no longer supports my custom number format. Does anyone know how I can still achieve this?

E.g., a vertical stacked-bar chart where segments with positive values (50%, 35%) go above the horizontal line and negative values (-15%) below it, but instead of showing "-15%," I'd like it to display "15%" in the negative segment, instead, and still stay below the line.



I'm pretty sure I should be able to format the number with custom formatting, but the syntax must have changed.

Much appreciated!

Double click the value axis

Choose Number > Custom and add ##;## or ##%;##% might work

__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials

Your second suggestion: ##%;##% works for percentages - thank you very much, JohnWilson!

I also played around and found the following to work with percentages as well: #%;#% and 0%;0%. It doesn't seem to make any difference which format I choose, in my example.

The first one looks like the code for whole numbers, but I haven't tried it since my chart is set up for percentages.

Glad it worked!

__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials