I am working with a chart and I’m trying to figure out how to make this chart grow continually without having to go in and redefine my ranges everytime I add information. I realize it will update if I change or add information within my defined range, but I add info to this chart everyday and I need the chart to reflect this. I know there is a way to do this by inserting a name for my range and using the OFFSET funtion in my “refers to field” spot, but I can’t get it to work. Anyone want to take a stab at this? I know it can be done. I’ll even email you the exact spreadsheet I’m working with. Please help!
