+ Reply to Thread
Results 1 to 5 of 5

Trying to change the bounds of the x axis of a line graph

  1. 06-30-2020, 06:06 AM #1
    Stovasaurus
    Stovasaurus is offline
    Registered User
    Join Date
    06-30-2020
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    3

    Trying to change the bounds of the x axis of a line graph

    I know this sounds super simple, but I've been searching online and trying to figure it out for days now. I have a simple line graph:

    Screenshot (41).png

    and the x axis is a series of data, various points from 0 to 139. I simply want to change the way the x axis is displayed so it goes from 0 to 160, with intervals of 20. Am I missing something simple here? Any help would be appreciated.
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 06-30-2020, 08:45 AM #2
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Trying to change the bounds of the x axis of a line graph

    Line charts have categories, or dates, on the horizontal axis.

    If you want a numeric horizontal axis you need to use a xy-scatter chart type
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  3. 06-30-2020, 09:30 AM #3
    Stovasaurus
    Stovasaurus is offline
    Registered User
    Join Date
    06-30-2020
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Trying to change the bounds of the x axis of a line graph

    Thanks for the info, I didn't realise this. So there's no way I can have a line graph with custom x axis limits?
    Last edited by AliGW; 06-30-2020 at 09:32 AM. Reason: Please don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  4. 06-30-2020, 09:36 AM #4
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Trying to change the bounds of the x axis of a line graph

    Yes, use a xy scatter chart.
    Use the format of lines and markers
    Reply With QuoteRegister To Reply
  5. 06-30-2020, 09:28 PM #5
    Stovasaurus
    Stovasaurus is offline
    Registered User
    Join Date
    06-30-2020
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Trying to change the bounds of the x axis of a line graph

    Perfect! I knew it was something simple. Thanks so much.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Line graph with 2 y-axis not showing correct x-axis labels
    By TheRobsterUK in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-26-2020, 12:15 PM
  2. changing axis in line graph - label axis should be on y-axis
    By Falimus in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-24-2020, 04:56 PM
  3. Possible to automatically have "tighter" X and Y-axis bounds in a simple line chart?
    By ajkessel in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-02-2020, 11:20 AM
  4. Excel graph- two bounds on X Axis
    By cindy100 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-23-2019, 08:57 AM
  5. Select Date and Change Line Graph X-Axis
    By Branbran10 in forum Excel General
    Replies: 1
    Last Post: 01-26-2016, 01:39 PM
  6. [SOLVED] VBA for changing the x-axis bounds in a graph
    By lrouquette in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2015, 07:18 PM
  7. can I make the vertical axis the category axis in Excel line graph
    By power1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-20-2006, 04:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1