+ Reply to Thread
Results 1 to 5 of 5

Excel dates on chart are cut off short..

  1. #1
    Registered User
    Join Date
    07-08-2014
    Location
    US
    MS-Off Ver
    Office 2007
    Posts
    3

    Excel dates on chart are cut off short..

    Hello,
    I am working with the spreadsheet and have a chart. I have listed a number of years and it is cut off a couple years prior to the end range (2014). This is a spreadsheet that I downloaded and added a couple extra years (if that could be the problem).. The range of years in the formula appears to be correct.. Any help would be greatly appreciated!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-07-2014
    Location
    Adelaide, Australia
    MS-Off Ver
    MS Office 2010
    Posts
    8

    Re: Excel dates on chart are cut off short..

    example(1).xlsx

    Hey There,
    You had a Maximum set on your Horizontal axis to 01/12/2012 - I have changed this to the end date of your data.

    Cheers

    Ben

  3. #3
    Registered User
    Join Date
    07-08-2014
    Location
    US
    MS-Off Ver
    Office 2007
    Posts
    3

    Re: Excel dates on chart are cut off short..

    Thanks a lot. I didn't know that was there.

  4. #4
    Registered User
    Join Date
    05-29-2018
    Location
    Cape Town, South Africa
    MS-Off Ver
    2010
    Posts
    5

    Re: Excel dates on chart are cut off short..

    Hi guys,

    I have a similar issue as the gent above but am struggling to fix it. I have been using this chart for a few years but suddenly, even though the horizontal axis moves with the new dates the numbers of the line charts do not update.

    For eg the Institutional number ends at 138 but if you look at the chart, the line is still well above 140. The same thing with MSCI WI.

    Any assistance would be greatly appreciated.
    Attached Files Attached Files

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Excel dates on chart are cut off short..

    Quote Originally Posted by dann3h View Post
    Hi guys,

    I have a similar issue as the gent above but am struggling to fix it. I have been using this chart for a few years but suddenly, even though the horizontal axis moves with the new dates the numbers of the line charts do not update.

    For eg the Institutional number ends at 138 but if you look at the chart, the line is still well above 140. The same thing with MSCI WI.

    Any assistance would be greatly appreciated.
    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. stock chart: create multiple short vertical line
    By DavidRoger in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 01-05-2014, 08:52 PM
  2. Excel Line Chart - 12 month chart moving with dates
    By rockycj in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-13-2013, 06:41 PM
  3. adding dates w/o skipping short months
    By DrSzabo in forum Excel General
    Replies: 3
    Last Post: 05-20-2011, 04:56 PM
  4. Short dates coming up in US format if day is less then 13
    By jamesp@premiercs.co.uk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2006, 08:00 AM
  5. [SOLVED] How do I get the dates on an excel chart to stay as dates instead.
    By Rani in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-20-2005, 01: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