+ Reply to Thread
Results 1 to 3 of 3

Chart axis

  1. #1
    Registered User
    Join Date
    10-09-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    35

    Chart axis

    Hi All

    I want to extend my horizontal axis (days) from 14 to 20. If I click select data it allows me to 'edit' my horizontal axis by highlighting another selection. However, this is not actually represented on the graph, it remains at what it was. Is there an easy way to do this or am I missing a step?

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Chart axis

    Hi Jason,

    If I am not mistaking it...click on chart and then go to ribbon menu option "Layout" -> now select the axis in left side drop down and click on "format selection" and now do the editing.



    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Chart axis

    Or:-
    1. Select your plot line
    2. Right click and select "Add Trendline"
    3. At the bottom of the trendline popup you can extend the data forwards by n periods - just add 6
    Elegant Simplicity............. Not Always

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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