Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph does not copy with the tab
I am using Excel 2007 and have a graph on the same page as the data. I want
to copy this tab into the same workbook and then tweak the data. I right click on the tab, check the copy box, and Ok. The problem I have is that the graph does not copy with the tab. I get all the data that was on the tab I copied from, but the graph object did not come with the tab. Why not? Is there a setting in excel to get the graph object to copy with the tab? Thanks, Dean |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph does not copy with the tab
That is not how it should behave. I have just followed your steps and my
chart appears in the copy. Anyway, try this and see it the result is different: hold down CTRL, click the tab of the worksheet with chart - you should see a 'piece of paper' icon with a +; drag to new location and release CTRL. This is now I make duplicates of sheets. Is the chart there? best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "dbonline" wrote in message ... I am using Excel 2007 and have a graph on the same page as the data. I want to copy this tab into the same workbook and then tweak the data. I right click on the tab, check the copy box, and Ok. The problem I have is that the graph does not copy with the tab. I get all the data that was on the tab I copied from, but the graph object did not come with the tab. Why not? Is there a setting in excel to get the graph object to copy with the tab? Thanks, Dean |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph does not copy with the tab
Bernard,
Thanks for the reply. I tried your suggestion and still had the same issue. Now for the interesting part. I went to a collegues computer, using the same file, and the copy worked correctly. Any thoughts? I am thinking it may be an installation issue. Thanks, Dean "Bernard Liengme" wrote: That is not how it should behave. I have just followed your steps and my chart appears in the copy. Anyway, try this and see it the result is different: hold down CTRL, click the tab of the worksheet with chart - you should see a 'piece of paper' icon with a +; drag to new location and release CTRL. This is now I make duplicates of sheets. Is the chart there? best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "dbonline" wrote in message ... I am using Excel 2007 and have a graph on the same page as the data. I want to copy this tab into the same workbook and then tweak the data. I right click on the tab, check the copy box, and Ok. The problem I have is that the graph does not copy with the tab. I get all the data that was on the tab I copied from, but the graph object did not come with the tab. Why not? Is there a setting in excel to get the graph object to copy with the tab? Thanks, Dean . |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph does not copy with the tab
I think I would try a repair.
See http://support.microsoft.com/kb/924611 best wishes Bernard "dbonline" wrote in message ... Bernard, Thanks for the reply. I tried your suggestion and still had the same issue. Now for the interesting part. I went to a collegues computer, using the same file, and the copy worked correctly. Any thoughts? I am thinking it may be an installation issue. Thanks, Dean "Bernard Liengme" wrote: That is not how it should behave. I have just followed your steps and my chart appears in the copy. Anyway, try this and see it the result is different: hold down CTRL, click the tab of the worksheet with chart - you should see a 'piece of paper' icon with a +; drag to new location and release CTRL. This is now I make duplicates of sheets. Is the chart there? best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "dbonline" wrote in message ... I am using Excel 2007 and have a graph on the same page as the data. I want to copy this tab into the same workbook and then tweak the data. I right click on the tab, check the copy box, and Ok. The problem I have is that the graph does not copy with the tab. I get all the data that was on the tab I copied from, but the graph object did not come with the tab. Why not? Is there a setting in excel to get the graph object to copy with the tab? Thanks, Dean . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy a graph that I want to modify in powerpoint? | Charts and Charting in Excel | |||
Copy a graph to a new workbook | Charts and Charting in Excel | |||
how do I copy a graph from excel 2003? | Excel Discussion (Misc queries) | |||
How do I copy a graph so that I can paste it into Photoshop? | Charts and Charting in Excel | |||
Copy Pivot graph | Excel Worksheet Functions |