ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combine worksheets with graphs into one file (https://www.excelbanter.com/excel-discussion-misc-queries/70692-combine-worksheets-graphs-into-one-file.html)

Elliot

Combine worksheets with graphs into one file
 
I have many spreadsheets with data and graphs which I need to combine as tabs
in one workbook. When I cut and paste sheets, the graphs remain linked to
the old sheets. All of the rows, columns and data are the same, so is there
an easy way to break the link and get the graph pointed at the new sheet
without editing each series?


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com