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 2 of 2

Hybrid View

  1. #1
    New Member
    Join Date
    Sep 2021
    Posts
    5

    Performance Graph

    Hi

    My graph doesnt start on the first day ive starting entering data.

    https://ibb.co/DK9Wrw1



    Is this normal or can i do something to change it to beging in the bottom left corner? Also is it possible to view the graph just showing the reuslts with the faily high/low as well?

    Thanks

  2. #2
    Moderator
    Join Date
    Aug 2011
    Posts
    989
    Hi Prime, that is normal and is due to Excel using Auto values for the maximum and minimum values for the x-axis of the graph.

    You can manually change the horizontal axis so that your first bet date coincides with the vertical axis. If you scroll far to the right on the Bets worksheet you will find the data used for the graph. The column head is "Used for Performance Graph". Unlock the Bets worksheet (password is sport), select an empty cell somewhere above and set its formula equal to the value of the earliest date (e.g. =BH12, depending on your version, or you can simply enter the actual first date). Then right click on that cell, select Format Cells -> Number -> General. This will give you a number like 44440, or something like it. Then in the Performance Graph click on the x-axis, right click and select Format Axis. Under Axis Options, for Bounds set the minimum to the number you obtained in the Bets worksheet (e.g. 44440). After a few seconds the graph should be redrawn with your first date appearing in the bottom left corner.

    The daily highs and lows are actually shown on the graph as vertical lines on particular days. If you're looking for a new graph type that shows the details differently, go back to the Bets worksheet "Used for Performance Graph" area, highlight the relevant cells and then create a new graph of your own.

 

 

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
  •