+ Reply to Thread
Results 1 to 1 of 1

Copied chart initializes the date axis

  1. #1
    Registered User
    Join Date
    04-09-2014
    Location
    Lansing, MI, USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Copied chart initializes the date axis

    I report the status of development and testing for the releases of a significant system for the State of Michigan. I import data into several worksheets of an Excel workbook which allows me to format it for my reports. I produce, among the reported information, a chart showing the progress of testing effort (test cases passed vs. test cases not passed) from the beginning of testing until the scheduled implementation date. The relevant worksheet is attached. Also attached is a Word document into which is pasted the graph when I send out my reports by email or prepare my working document.

    The problem is that the date axis on the graph after pasting is initialized to Jan 1, 1900. It is easy to see that the dates in the data run from April 20, 2020 to June 13, 2020, with no improperly formatted cells in the Date column which is the source of the Date axis. What's going on with my date axis?

    Unsurprisingly, there are constraints.
    My shop uses Microsoft Office 365. I observed this problem starting last week after my Office installation prompted me for updates, which I accepted. I cannot say that I know this is the origin of the problem.
    Although I have administrator privileges to my machine, software updates are tightly constrained by State of Michigan's network administrators.
    The original spreadsheet resides on a shared network drive, to which I export the raw data from the project management application. The attached spreadsheet was saved to my work computer's desktop then the other worksheets deleted that do not pertain to this problem.
    State of Michigan network constraints do not allow me to access this forum. I emailed the workbook and the copied graph to my personal email account and am composing this on my personal laptop.
    I do not have Office 365 at home, but Office Professional 2016. This problem does not occur when I paste the graph from the worksheet I emailed to myself into a document on my home PC.
    If I Paste the chart as a Picture, the correct dates are shown. This may be an acceptable solution as far as my users are concerned, but I would like to know how I can copy the chart as it is with the correct dates.
    Attached Files Attached Files

+ 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. Replies: 1
    Last Post: 11-20-2015, 12:50 PM
  2. Line chart with time (mm:ss) on Y axis, and date on X axis
    By Epitome_Inc in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-28-2015, 02:36 PM
  3. Chart Axis in terms of Dates/Other Chart Date Questions
    By jp470519 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-09-2014, 06:27 AM
  4. 2D Bar Chart - Date X axis
    By jabbabroadley in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-13-2014, 12:28 PM
  5. [SOLVED] chart date axis
    By ProtoVB in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-27-2014, 06:32 AM
  6. Chart and date on X axis
    By Saxjazz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-11-2008, 09:21 AM
  7. how to draw a chart using x,y axis not the date with x-axis?
    By elshohna in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-12-2005, 08:25 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