+ Reply to Thread
Results 1 to 3 of 3

Line chart values shows deviation from real data

  1. #1
    Registered User
    Join Date
    06-07-2013
    Location
    Saint-Petersburg
    MS-Off Ver
    Excel 2003
    Posts
    1

    Line chart values shows deviation from real data

    I work in a mutual fund and complete statistical chart for share prices. The line chart on several dates shows wrong values. I examined the chart's options and everything seems to be correct. In general it looks normal, but on some dates it shows impossible rapid movements and most recent chart values do not correspond to real data.

    P.S. A week ago we had a virus attack and this table was restored. Can it be the cause of its strange behaviour

    Thanks in advance.

  2. #2
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    245

    Re: Line chart values shows deviation from real data

    1. Check your source data and confirm it's correct.

    2. Try starting the graph from scratch if not too time consuming, using the same data.

    3. Upload a copy of the spreadsheet. If it contains proprietary information, you can substitute mock data into it to protect confidentiality.

    Yes, it's possible the virus affected it: I am no virus expert but I do know they can cause all sorts of havoc I can't even imagine!
    <--- If you like the answer, press *.

  3. #3
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: Line chart values shows deviation from real data

    And if the date is in mmm-yy format, check the date of those months
    if 1-jun-13 is there in one cell and 2-Jul-13 is there is another cell after dragging, chart may not be perfect

+ 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