I have a series of charts whose data series add a number of rows every year. I would like to come up with a way that I could update all charts by changing one value, once. The number of rows of data that are added each year varies, but is always the same for all charts in the given year. The way I update them currently is to go to the first chart, select the data series and change the end cell (i.e. from A100 to A173), then I go to the next chart, select the data series and change B100 to B173, so on and so forth, for all 50+ charts. I could give each range a name and just update the range in the Name Manager instead, but I would still be doing that for the 50+ named ranges. I thought maybe I could make a separate sheet with two cells named "start" and "end", in which I would put the start and end row values and then in the chart set the start and end of the data series to SHEET1!A"start":A"end"........SHEET!B"start":B"end", but that doesn't want to work either. Is there some way I can do this?
TIA
Brett