+ Reply to Thread
Results 1 to 6 of 6

Number formatting: Not dividing by thousand in graph

Hybrid View

  1. #1
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,385

    Re: Number formatting: Not dividing by thousand in graph

    We might need a better description, or even a sample spreadsheet uploaded to the forum. I cannot recreate the problem. When I apply a suitable "divide by 1000" format to a pivot chart, it formats correctly.
    Attached Files Attached Files
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  2. #2
    Registered User
    Join Date
    06-19-2015
    Location
    Oslo
    MS-Off Ver
    2016
    Posts
    21

    Re: Number formatting: Not dividing by thousand in graph

    Thank you so much for the reply!

    I have modified your file a bit(pivotchartaxisformatexample.xlsx).

    The pivot table has the number formatting I am after, but the chart labels doesn't. In the pivot table the numbers are divided by 1000, but when I try to do the same with the chart labels something strange happen.

    I am using Excel 2013, btw.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] UDF required to convert number with k to Thousand and with m to Million
    By prkhan56 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2015, 03:12 PM
  2. copy the thousand number only
    By choy96 in forum Excel General
    Replies: 4
    Last Post: 03-30-2010, 06:53 AM
  3. Number Format: One Thousand = 1K, One Million = 1M
    By emptycucumber in forum Excel General
    Replies: 5
    Last Post: 05-29-2009, 10:47 PM
  4. Replies: 3
    Last Post: 08-08-2006, 02:30 PM
  5. SPELL NUMBER IN ENGLISH i.e 1,000 RESULT IS ONE THOUSAND ONLY
    By JAWAD CHOHAN in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2005, 05:45 AM
  6. [SOLVED] How can I format number into thousand?
    By Roni in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-09-2005, 01:05 PM
  7. how to read number as string like '1243 = One thousand..'
    By pc_1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-27-2005, 07:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1