PDA

View Full Version : Cells used for Performance Graph



bocko
14th September 2017, 12:17 AM
Hello!

I've been using betting tracker for many years now and it is working perfectly for me. Great work!

The only thing it bothers me is that I cannot make performance graph work. It looks like this:
http://shrani.si/f/2P/t1/3JZx61lu/performancegraph.jpg

When I go to Bets- Used for Performance Graph the dates are ok, but the profit is not working correctly. It suddenly comes to a point when it goes just a bit up and down and it is wrong - should go up :) How can I find an error?

Thank you very much!

admin
14th September 2017, 11:21 AM
Hi bocko, my recommendation is to unlock the bets worksheet (using the password sport), then select one of the profit cells that is working perfectly. Excel will display a green border around it with a green box in the bottom right hand corner of the cell. Move your cursor over this box, then click and drag down over the remaining profit cells in the column. This will overwrite their formulas with the formula of the working cell.

Another option is to paste all of your data into a fresh copy of the spreadsheet and see if the problem still exists.

If that doesn't work, send me a PM and I will give you an email address that you can send a copy of your spreadsheet to.

bocko
14th September 2017, 07:18 PM
Hi bocko, my recommendation is to unlock the bets worksheet (using the password sport), then select one of the profit cells that is working perfectly. Excel will display a green border around it with a green box in the bottom right hand corner of the cell. Move your cursor over this box, then click and drag down over the remaining profit cells in the column. This will overwrite their formulas with the formula of the working cell.

Another option is to paste all of your data into a fresh copy of the spreadsheet and see if the problem still exists.

If that doesn't work, send me a PM and I will give you an email address that you can send a copy of your spreadsheet to.

Working now. Thank you master.