Thank you DocAElstein for helping me. As you can see in the picture I changed the ratio to 3 and the limit to 600. In the picture you see that it's confusing because columns G H and I are still there which are not needed because they are now C D and E. and then you see that the calculations stop at 520 in D103 and continue with 1's and 4's. I need it to continue calculating to 600 or to whatever number I put as the limit in B3chart1returnpic.jpg