+ Reply to Thread
Results 1 to 7 of 7

Excel Chart Date is Showing Wrong Date

  1. #1
    Registered User
    Join Date
    04-10-2016
    Location
    Bangladesh
    MS-Off Ver
    Office Professional Plus 2016
    Posts
    68

    Excel Chart Date is Showing Wrong Date

    Hlw,
    Please help me, My Excel Chart is showing Wrong Date

    https://volafile.io/get/EGyLPqEIw67_...2016(new2).xls

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,769

    Re: Excel Chart Date is Showing Wrong Date

    can you attach a sample to the forum post - rather than point to a website , which is reported as harmful and contains malware (at least according to the security tools i have on my PC)
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,397

    Re: Excel Chart Date is Showing Wrong Date

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Registered User
    Join Date
    04-10-2016
    Location
    Bangladesh
    MS-Off Ver
    Office Professional Plus 2016
    Posts
    68

    Re: Excel Chart Date is Showing Wrong Date

    File Uploading is not working on my PC

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,397

    Re: Excel Chart Date is Showing Wrong Date

    See my post above yours - you need to Go Advanced, then scroll down and use MANAGE. The paper clip icon is not working, and hasn't been working now for quite some time.

  6. #6
    Registered User
    Join Date
    04-10-2016
    Location
    Bangladesh
    MS-Off Ver
    Office Professional Plus 2016
    Posts
    68

    Re: Excel Chart Date is Showing Wrong Date


  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,397

    Re: Excel Chart Date is Showing Wrong Date

    Right-click the horizontal axis labels and choose Select Data ...

    Edit the horizontal category to take its values from the correct range (='May 2016 Data sheet'!$A$4:$A$34).

+ 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. Slicer for table with date column showing wrong result
    By p3rlend in forum Excel General
    Replies: 1
    Last Post: 04-24-2016, 06:37 AM
  2. Excel Chart Showing Wrong Month
    By rtabaldi in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-19-2013, 05:25 AM
  3. Line showing todays date in chart
    By D-smoke in forum Excel General
    Replies: 3
    Last Post: 12-19-2012, 01:15 PM
  4. Combo box cell link showing wrong date
    By kojo in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-29-2011, 05:51 AM
  5. VBA Save w/ date showing Wrong Date
    By CBG05QB in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-13-2011, 12:23 PM
  6. Wrong date on x-axis in line chart
    By sorent in forum Excel General
    Replies: 2
    Last Post: 12-26-2010, 05:39 PM
  7. Pivot table showing wrong data (date not month)
    By rushdenx1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2010, 06:59 AM

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