Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-14-2013, 02:13 PM
todor todor is offline Custom formatting to make negative numbers show w/o negative sign on charts Windows 7 64bit Custom formatting to make negative numbers show w/o negative sign on charts Office 2010 64bit
Novice
Custom formatting to make negative numbers show w/o negative sign on charts
 
Join Date: Jan 2013
Location: Boston, MA
Posts: 2
todor is on a distinguished road
Default Custom formatting to make negative numbers show w/o negative sign on charts

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!
Reply With Quote
  #2  
Old 01-15-2013, 08:45 AM
JohnWilson JohnWilson is offline Custom formatting to make negative numbers show w/o negative sign on charts Windows 7 64bit Custom formatting to make negative numbers show w/o negative sign on charts Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,855
JohnWilson will become famous soon enoughJohnWilson will become famous soon enough
Default

Double click the value axis

Choose Number > Custom and add ##;## or ##%;##% might work
__________________
Microsoft PowerPoint MVP
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #3  
Old 01-15-2013, 09:04 AM
todor todor is offline Custom formatting to make negative numbers show w/o negative sign on charts Windows 7 64bit Custom formatting to make negative numbers show w/o negative sign on charts Office 2010 64bit
Novice
Custom formatting to make negative numbers show w/o negative sign on charts
 
Join Date: Jan 2013
Location: Boston, MA
Posts: 2
todor is on a distinguished road
Lightbulb Problem solved thanks to JohnWilson!

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.
Reply With Quote
  #4  
Old 01-16-2013, 03:45 AM
JohnWilson JohnWilson is offline Custom formatting to make negative numbers show w/o negative sign on charts Windows 7 64bit Custom formatting to make negative numbers show w/o negative sign on charts Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,855
JohnWilson will become famous soon enoughJohnWilson will become famous soon enough
Default

Glad it worked!
__________________
Microsoft PowerPoint MVP
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
Reply

Tags
number formatting

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom formatting to make negative numbers show w/o negative sign on charts If formula result is negative then display text oxicottin Excel 3 12-03-2012 02:12 AM
Custom formatting to make negative numbers show w/o negative sign on charts Custom Bar Charts SMartinez PowerPoint 1 05-18-2012 05:20 AM
Sum required without consider the negative amount PRADEEPB270 Excel 2 08-22-2011 04:23 AM
Start slides from a negative number powerpointbry PowerPoint 12 06-29-2011 12:14 AM
Custom formatting to make negative numbers show w/o negative sign on charts How to add the plus sign (+) automatically for the numbers which are positive? Jamal NUMAN Excel 2 05-01-2011 03:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft