How to copy data with corresponding chart so the new chart references the new data?
Posted on 2016-11-15
We had a survey with a number of questions. I would like to be able to copy the chart down the number of times for the number of questions and have each new chart updated to the new data.
For instance, I already pull the data in A2 – H6 via formula, so I can easily copy the rows down to get the new data. However, how would one have a reference to this ranges of cells in the chart to the right that as you copy the rows down, the chart range would automatically change to the data in the new rows?
For example, I would love to be able to copy rows 2-6 with the chart referencing data in A2 – H6 into rows 7-11 and have the second chart reference automatically change to the data in A7 – H11.
I don’t want to have to go into each chart and change the range manually each time for all the charts – but, I have the distinct impression that I may have to. BTW - no VBA please. I don't think this would be worth the time and effort of VBA.
Any help would be appreciated. Thanks much! Great forum!