Welcome guest, is this your first visit? Create Account now to join.
  • Login:

Welcome to the Australia Sports Betting Forum.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Betfair
Results 1 to 4 of 4
  1. #1
    New Member
    Join Date
    Apr 2016
    Posts
    4

    performance graph

    Hi, i have very limited knowledge of Excel. I've read through a few posts and cant fix this problem. My graph is all wrong.
    If i scroll all the way right on the bets tab i have a few #REF! where the dates should be and have no clue how to fix it.

  2. #2
    Moderator
    Join Date
    Aug 2011
    Posts
    989
    Hi msr49,

    My guess is that some rows have been deleted from the Bets worksheet. This can throw off background calculations.

    It may be possible to tweak the working cell calculations to fix the issue, but my recommendation is to paste your data into a fresh copy of the spreadsheet. If that doesn't fix the issue, send me a PM and I'll give you an email address that you can send a copy of your spreadsheet to.

  3. #3
    New Member
    Join Date
    Apr 2016
    Posts
    4
    Thanks.
    I think i tried to copy the date column to save typing in the date each time after a huge betting day Saturday and Sunday.
    Do you think that's what caused it?

  4. #4
    Moderator
    Join Date
    Aug 2011
    Posts
    989
    Copying and pasting date values shouldn't cause any problems. I do it all the time, but I guess it depends on how you did it. Issues most often arise due to rows being deleted.

 

 

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
  •