Thread: Alternative to manually updating source data?

Hi there

First post so apologies in advance if I am not porviding the right information or in the right format.

I have an excel spreadsheet with over 150 rows of data and for each one I have created a stacked chart with a couple of XY points on it. The chart looks fine and works for what I have in mind but each of the charts point to the same original data source and not the respective rows. I have strated to update manually but to be honest I am up against the clock and it is going to take me hours to update each chart.

Is there anyway of doing it automatically? or should I start again but in a more sensible way?

thanks!