Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

Tags
number formatting



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 06:01 PM.


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