ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   HELP!! Charts won't copy across to another worksheet (https://www.excelbanter.com/charts-charting-excel/110368-help-charts-wont-copy-across-another-worksheet.html)

David G Broadbent

HELP!! Charts won't copy across to another worksheet
 
Help Please.
I have a sheet which has all my descriptive stats on it and graphs drawn
from this data. There are 100 charts on the sheet. I am trying to copy the
whole sheet WITH the CHARTS. Then I shall only have to change some of the
formulas to perform other comparisons. My problem is whichever means I sue
to copy the sheet the data cells copy. The gaps are there where the charts
should be. NO CHARTS. Any advice grateful received.



Bernard Liengme

HELP!! Charts won't copy across to another worksheet
 
Have you tried making a second copy of the sheet by holding down CTRL and
dragging the sheet tab to the right?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"David G Broadbent" wrote in message
...
Help Please.
I have a sheet which has all my descriptive stats on it and graphs drawn
from this data. There are 100 charts on the sheet. I am trying to copy the
whole sheet WITH the CHARTS. Then I shall only have to change some of the
formulas to perform other comparisons. My problem is whichever means I sue
to copy the sheet the data cells copy. The gaps are there where the charts
should be. NO CHARTS. Any advice grateful received.




terry

HELP!! Charts won't copy across to another worksheet
 
Last time this happen to me, was because the charts and chart data are not in
the same sheet.
Or maybe charts/data set have additional link at somewhere else.
That was what I have been told.

Have you try using move or copy command?

"David G Broadbent" wrote:

Help Please.
I have a sheet which has all my descriptive stats on it and graphs drawn
from this data. There are 100 charts on the sheet. I am trying to copy the
whole sheet WITH the CHARTS. Then I shall only have to change some of the
formulas to perform other comparisons. My problem is whichever means I sue
to copy the sheet the data cells copy. The gaps are there where the charts
should be. NO CHARTS. Any advice grateful received.





All times are GMT +1. The time now is 10:13 PM.

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