Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-20-2017, 06:59 AM
gebobs gebobs is offline Data label precision Windows 7 64bit Data label precision Office 2010 64bit
Expert
Data label precision
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default Data label precision

I use the format [>=1000]#,##0,"K";General to display data labels using a K to denote thousands.

This makes something like 1,457,735 appear as 1,458K. Simple enough.

Is there a way to reduce the precision to perhaps three significant figures i.e. 1,460k?
Reply With Quote
  #2  
Old 06-20-2017, 06:29 PM
Logit Logit is offline Data label precision Windows 10 Data label precision Office 2007
Expert
 
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

If 1,458 were in D6, try this formula in E6

Code:
= ROUND((D6 ) / 10, 0) * 10
I tried using the formula with the K still attached to the end of the 1,458 but it threw
off the formula. So, if you can determine how to make the change prior to adding the K you should be good.
Reply With Quote
  #3  
Old 06-21-2017, 06:21 AM
gebobs gebobs is offline Data label precision Windows 7 64bit Data label precision Office 2010 64bit
Expert
Data label precision
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

I would prefer to only change the display of the label. Your solution will change the actual value of the cell. I suspect it's the only solution so will probably have to go with that.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Data label precision Sum scattered data with same label pfarrelli Excel 3 12-28-2016 02:07 PM
Pie chart showing more than one data label chickasaw Excel 2 03-10-2015 07:27 PM
Can't move objects with precision MLF PowerPoint 3 07-31-2014 04:03 AM
Display a label character in a data cell markg2 Excel 9 09-07-2013 05:56 AM
Trying to merge label data from file ClayShannon Mail Merge 0 09-16-2009 10:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:44 AM.


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