Chart disappears when I copy tab or move to another workbook

[strattergize]

In versions prior to Excel 2007, I was always able to copy a chart when I copied a tab. However, when I copy a tab in 2007, the data copies fine, but the chart does not. Something similar happens when I try to move a tab with a chart on it to another workbook.

This is a big problem for me as I work with a lot of charts. Are there any known fixes around this, or any good solution (short of recreating the chart from scratch)?

Thanks in advance.

Jared

 

[Akashwani]

Hi Jared,
Welcome to MrExcel.

This works fine for me, click between the 1 and A in the top left hand corner of your worksheet, right click Copy, go to your new Tab, click in A1, right click Paste.

Good luck.

Ak

 

[strattergize]

Thanks for the help. I appreciate it.

Jared

 

[gouache]

I am having the same problem as strattergize reported.

I have been working with the same Excel file for 6+ months. Every week I copy an existing worksheet, change some data, and save a new version.

However this week, when I copy/paste, the data appears when I paste but none of the charts appear. I have tried copying the tab itself, and creating a new tab and manually pasting everything over. To no avail.

Suggestions???

 

[Akashwani]

Hi, Welcome to MrExcel.

Have you tried my previous suggestion?
If so, I'm sorry but I don't have an alternative solution for you.

Ak

 

[gouache]

Yeah, I did ... (sorry that's what I was trying to convey with "creating a new tab and manually pasting everything over").

Sigh.

 

[mrlarge]

I had a similar problem pasting a chart from one tab to another within the same worksheet. It disappeared, but is still there in print preview. I can not see the chart in any layout or delete it. When I use "Page break preview" a blank page shows.

Does anyone know how to get rid of the page, or the chart? It shows up when I print PDF's and I don't want it there.

Thanks!!

 

[thisoldman]

Ctrl+6 is the keyboard shortcut to toggle the display of objects in the worksheet. Perhaps hitting that key combination a few times will bring the chart back?

Alt+F10 brings up the selection pane in Excel 2013 and 2016; that's identical to the ribbon command "Page Layout >> Selection Pane". On the Home tab, You can get to object selection from Find & Select. That might be of use to find the chart.

Have you tried inserting another chart? Try that and, with that new chart selected, press Ctrl+A. That should select all worksheet objects. From there you might be able to Tab through to the chart you want, if it is not hidden.