+ Reply to Thread
Results 1 to 3 of 3

Line spacing in tick labels

  1. #1
    Registered User
    Join Date
    04-05-2017
    Location
    Houston, TX
    MS-Off Ver
    2016
    Posts
    57

    Line spacing in tick labels

    I have a chart that plots a series of values over time. The x-axis number format is mm/dd/yyyy hh:mm:ss and I have a line break to place the date and time on two separate lines. However the line spacing seems to be wasting a lot of spacing (it looks like double spaced font to me). Is there any way to change this? It might not seem like a big deal but I have a specific use for these charts that would really benefit from being able to use that extra space for a larger plot area.

    I've attached a sample file.

    Thanks in advance.
    Attached Files Attached Files

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

    Re: Line spacing in tick labels

    I applied a custom number format to the source cells used for horizontal axis

    If the number format dialog use the numeric keypad to enter 0010 < ENTER > between date and time parts of the format.
    < ENTER > means press the enter key on the numeric keypad. If done correctly the time section will appear to disappear from the input box on the dialog.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-05-2017
    Location
    Houston, TX
    MS-Off Ver
    2016
    Posts
    57

    Re: Line spacing in tick labels

    Perfect.

    I had seen a few references to the ASCII line break command before but I forgot about it and didn't know how to use it here. Thanks.

+ 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. how can x-axis labels be centered between tick marks
    By umbata in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-12-2014, 10:31 AM
  2. Fixing NumberFormat on Tick Labels
    By Jerseynjphillypa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2012, 01:52 PM
  3. [SOLVED] Minor Tick Mark Labels in Charts
    By jacksonstorms in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-26-2012, 05:37 AM
  4. Line Wrap in Axis Tick Labels
    By Mike Hogan in forum Excel General
    Replies: 0
    Last Post: 06-27-2006, 09:25 AM
  5. Change XY tick labels from numeric to text
    By jennifer in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-20-2006, 03:35 PM
  6. [SOLVED] Can tick mark labels be flipped about axis?
    By [email protected] in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-20-2005, 12:05 PM
  7. tick mark labels
    By Debrane in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 07-18-2005, 10:05 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