PDA

View Full Version : performance graph



msr49
14th April 2016, 02:06 PM
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.

admin
14th April 2016, 05:46 PM
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.

msr49
15th April 2016, 09:07 AM
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?

admin
15th April 2016, 10:13 AM
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.