+ Reply to Thread
Results 1 to 3 of 3

Insert 2-d line format axis alignment wrong position

  1. #1
    Registered User
    Join Date
    11-05-2018
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    30

    Insert 2-d line format axis alignment wrong position

    Greetings,

    I'm wondering how I make the dates go bot central? I've already selected that in under "format axis->size & properties"
    but my dates doesn't want to go below my graph line? Why is that? Please se the picture where I try to explain my graphing problem.

    Thanks!

    Sk?rmbild 2024-05-10 154749.png

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,883

    Re: Insert 2-d line format axis alignment wrong position

    Unless something has changed in your newer version, I think you are in the wrong formatting pane to move the axis labels to the bottom of the chart. Find the axis scale options and look for a "axis labels" field where you can specify "next to axis" "high" "low" "none" It looks like the current setting is "next to axis" and you are wanting "low"
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    11-05-2018
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    30

    Re: Insert 2-d line format axis alignment wrong position

    Thanks! It works now

+ 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] Change alignment dependant on position of sheet.
    By CDandVinyl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2023, 10:58 AM
  2. [SOLVED] horizontal axis format on line chart
    By Brian Itotia in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-08-2019, 02:13 PM
  3. Column and Scatter/Smoothed Line Chart - X-axis values appear in wrong place
    By Cheekybeelzebub in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-20-2015, 09:33 AM
  4. [SOLVED] Why can you not (seemingly) format x-axis colours in line charts
    By Yeldaw in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-21-2012, 10:22 AM
  5. line chart-format x axis for dates
    By Scatter in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-29-2011, 04:59 AM
  6. Vertical line alignment with X-axis
    By treesloth in forum Excel General
    Replies: 1
    Last Post: 06-17-2011, 04:14 AM
  7. Wrong date on x-axis in line chart
    By sorent in forum Excel General
    Replies: 2
    Last Post: 12-26-2010, 05:39 PM

Tags for this Thread

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