Copying Charts and graphs to another worksheet with formulas
I have made a worksheet with all my graphs, charts, etc.. on the same sheet.
All the data in the charts and graphs is automatically populated from 4 diferent tables. What do I need to do to be able to copy the graphs, charts (certain cells) to their individual spreadsheet and not loose the data or having the (#REF!). I have 5 tables, 4 graphs & 7 charts which are automatically populated from the above four tables. I would like to be able to send these individually to different departments in the Company. I am sure it's a simple solution but not breeing very good with excel I am stuck. Thanks to all who reply! Bebz |
Copying Charts and graphs to another worksheet with formulas
I would really appreciate come help with the problem below?
Thanks in advance, Bebz "bebz" wrote: I have made a worksheet with all my graphs, charts, etc.. on the same sheet. All the data in the charts and graphs is automatically populated from 4 diferent tables. What do I need to do to be able to copy the graphs, charts (certain cells) to their individual spreadsheet and not loose the data or having the (#REF!). I have 5 tables, 4 graphs & 7 charts which are automatically populated from the above four tables. I would like to be able to send these individually to different departments in the Company. I am sure it's a simple solution but not breeing very good with excel I am stuck. Thanks to all who reply! Bebz |
All times are GMT +1. The time now is 10:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com