I need to update several charts every day with new data added to a table. Is
there a quick way to update each series? Some Charts have 6 series and the x
axis is the dates, so these need to update also. Right now I type in the new
cell numbers everyday.
Day 1 would be c27:c40 tomorrow would be c28:c41 etc.....