If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 . |
Thread Tools | |
Display Modes | |
|
|