+ Reply to Thread
Results 1 to 2 of 2

Right-align Text on Combo-Chart Legend Excel 2016

  1. #1
    Registered User
    Join Date
    07-11-2014
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    9

    Right-align Text on Combo-Chart Legend Excel 2016

    I have a Combo Chart in Excel 2016 with the data increments displayed on the right side of the chart as follows:
    1,600
    1,400
    1,200
    1,000
    800
    600
    400
    200
    0

    How to I make this data right-aligned vs. left-aligned?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Right-align Text on Combo-Chart Legend Excel 2016

    You need to use a fixed space font and then a number format of ???,??0
    The number of ? depends on how many leading spaces you want
    Cheers
    Andy
    www.andypope.info

+ 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. Error '438' in Excel 2016 with combo box
    By c.davidson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2018, 09:10 AM
  2. [SOLVED] concatenate (&) text in 2 cells and add as chart Legend
    By NatalieW12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2017, 08:26 AM
  3. VBA excel to word insert footer (Text - Left align) & (Page number - Right align)
    By Richavlaues in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2017, 06:22 PM
  4. Marker size or shape in legend for combo chart
    By njs27 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-10-2016, 03:13 AM
  5. [SOLVED] Table has Text Values, but Chart Legend changes them to 0 (zero)
    By yamalady in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-07-2014, 06:57 AM
  6. Vertically align text in chart
    By EricN87 in forum Excel General
    Replies: 6
    Last Post: 02-27-2012, 10:39 PM
  7. [SOLVED] Change legend text in Excel Chart
    By quest in forum Excel General
    Replies: 1
    Last Post: 04-09-2005, 10:06 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