Jon,
Are you using 2003 or 2007? In my 2003 I use to do exactly what you mentioned. In 2007, I can no longer do the Move or Copy sheet tab. Only the data copies and NOT the chart.
Jon Peltier wrote:
The OP did not want to have to reset the source data range.
06-Jan-10
The OP did not want to have to reset the source data range
If the entire sheet including its embedded chart is copied, using fo
instance the Move and Copy command on the sheet tab's right click menu
the copied charts should reference the data on the copied sheet
I wrote about this on my blog
Copy Chart and Data and Preserve Link
http://peltiertech.com/WordPress/copy-chart-and-data-and-preserve-links
- Jo
------
Jon Peltie
Peltier Technical Services, Inc
http://peltiertech.com
trip_to_tokyo wrote:
Previous Posts In This Thread:
copying worksheet including graphs to new worksheet
I have a problem with finding an efficient method of copying an entir
worksheet including more graphs to a new worksheet without having to redefin
each date sets in the graphs to the name of the new worksheet
Can I define date in the graphs to copy so they ar refering to the workshee
they are included in?
If you use "Move or Copy Sheets" to copy a sheet to a new worksheet, anychart
If you use "Move or Copy Sheets" to copy a sheet to a new worksheet, an
chart references from the original sheet will automatically be to the ne
sheet on the copy. I am not clear as to how you are doing your copy
-
David Biddulph
You could try just saving the Workbook but give it a new name.
You could try just saving the Workbook but give it a new name. This wa
everything will be preserved in the new (additional) Workbook that yo
create
Please hit Yes if my comments have helped
Thanks
:
hi davidThe references in the dataseries in the graphs are not changed.
hi davi
The references in the dataseries in the graphs are not changed. they wil
still refer to the worksheet where it is copied from
"David Biddulph" skrev:
Not on mine (using Excel 2003).
Not on mine (using Excel 2003)
If a chart on sheet 1 has data series referring to sheet 1, when I produce
copy as sheet 1 (2), the chart on that sheet refers to data on sheet 1 (2)
which is what you were asking for
-
David Biddulph
I have just revisited this.In EXCEL 2007 take the following actions:-1.
I have just revisited this
In EXCEL 2007 take the following actions:
1. In Sheet 1 I have chart data in cells A 1 to B 7 inclusive
2. On the same Worksheet I have a Clustered Column chart set up against th
data in number 1
3. I now want to copy all the above data to Sheet 2
- click on the cell to the left of A and above number 1 to highlight th
whole of Sheet
- Ctrl-C to cop
- open a new Worksheet (Sheet2
- in cell A1 do a Ctrl-V (to paste the copied data
- all the data from Sheet1 (including the graph) gets copied to Sheet
- click on the graph in Sheet2 / right hand click / and choose Select Dat
- Select Data Source panel should now launc
- In here the Chart data range: is set to
='Sheet1'!$A$1:$B$
4. Change the above so that it reads:
='Sheet2'!$A$1:$B$
5. Click on OK
6. Save the file if required
You now have two sets of data on two different Worksheets both workin
independently of each other
If my comment s have helped please hit Yes
Thanks
:
The OP did not want to have to reset the source data range.
The OP did not want to have to reset the source data range
If the entire sheet including its embedded chart is copied, using fo
instance the Move and Copy command on the sheet tab's right click menu
the copied charts should reference the data on the copied sheet.
I wrote about this on my blog:
Copy Chart and Data and Preserve Links
http://peltiertech.com/WordPress/copy-chart-and-data-and-preserve-links/
- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/
trip_to_tokyo wrote:
MOVE or Copy Sheet w/ data and charts
Jon,
Are you using 2003 or 2007? In my 2003 I use to do exactly what you mentioned. In 2007, I can no longer do the Move or Copy sheet tab. Only the data copies and NOT the chart.
Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint - Managing Unused or Archive sites automatically
http://www.eggheadcafe.com/tutorial...5b-a2a8deb60cad/sharepoint--managing-unu.aspx