I have a sheet where I repeat the same formulas for different items every 41 lines. I have created graphs that fit within those lines and are based on the information gathered and calculated there. I tried to make the references for the graphs relative rather than absolute, but excel auto corrects it. Is there a way to stop that auto correction or repeat the graphs every 41 lines based on the lines within that new section? Any help is great. Thanks,