+ Reply to Thread
Results 1 to 4 of 4

Label formatting issue

  1. #1
    Registered User
    Join Date
    08-20-2014
    Location
    Rather not say
    MS-Off Ver
    10
    Posts
    3

    Angry Label formatting issue

    Hey,

    So I have a chart that shows millions on the vertical axis. When I right click on the axis and click format axis, I go to scale and change the number of display units to millions. This works fine as for example it changes the number on the vertical axis from 1,000,000 to 1M.

    However, the labels on the bar charts change from 1,234,567 for example to 1 but I don't want the label format to change I want it to stay the same. I'm not sure why the remainder of the number is getting cut off. Please advise how to fix this.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,077

    Re: Label formatting issue

    You've posted this enquiry twice which, according to the forum rules, is a "no, no".
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Label formatting issue

    You need to change the axis scale, not the format
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Label formatting issue

    tuph, thanks for the heads-up, the other thread has been closed

+ 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. Data Label Issue
    By zooropa33 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 05-08-2014, 01:46 AM
  2. [SOLVED] 100% stacked bar issue on data label
    By sarinky in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-02-2013, 07:08 AM
  3. Chart Data Label/Secondary Axis Issue
    By pdub84 in forum Excel General
    Replies: 0
    Last Post: 12-20-2011, 12:54 PM
  4. Pie chart and percent data label issue
    By drewship in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-04-2009, 09:36 AM
  5. Data Label - Window Resize Issue
    By mdalby in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-13-2006, 09:03 PM

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