Duplicate chart changing the set of values

[Lohoris]

I’ve made a chart with a set of values.

I need to make a new chart exactly like this one (changing only the title) in the same sheet, using a different set of values.

How do I do that?

I’ve noticed the original chart only has absolute cells (such as $B$1), basically I’d need the new chart to have all the cells in that chart to be shifted to a different point of the sheet…

(I’m not sure if what I wrote is clear, if it isn’t, please tell me and I’ll try to improve it)

edit: of course I can manually replace every single series, but that’s exactly what I was trying to avoid. What I would like to do is to automatically shift ALL series and values and Y error bars, etc.

edit2: now it got worse, even the sheet itself is absolute ($‘Sheet’), so if I duplicate the sheet, the new one will have graphics pointing to the old one… I can’t believe it…

[ROSt53]

create your chart and format it to what you need

click chart that you have green points around the chart

ctrl+C

click on target cell

ctrl+V

double click pasted chart to get into edit mode => grey frame with small black points around the chart

right click on chart

select data ranges

replace either data range with the new range

or

select data series and replace each series with new series of data

[ROSt53]

should you need assistant with replacing data ranges / series please advice