Use named ranges to define the series.
Make sure that any absolute references in the named ranges are not part of the cells you are likely to Cut+Paste over, otherwise just like the series formula the named ranges references will handle the change.
Use named ranges to define the series.
Make sure that any absolute references in the named ranges are not part of the cells you are likely to Cut+Paste over, otherwise just like the series formula the named ranges references will handle the change.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks