You will have to check the macro to see what it is doing. Clearly, the
chart has not disappeared if you can locate it by clicking around the
worksheet.

You may also want to check the setting of Tools | Options... | View tab
| Objects section. Make sure it is 'Show All'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I have data on one worksheet and a chart on another. The chart seems to
have resized itself or disappeared. If I click around, I can randomly
find things like titles and stuff, and even edit the values. If I
right click, I can change the chart type, and when I preview the chart
type selection, the chart displays properly. I have a macro running
that resizes the chart, based on a selection on the data worksheet, but
I'm not sure how that could have messed it up. Any ideas?


--
Coolboy55
------------------------------------------------------------------------
Coolboy55's Profile: http://www.excelforum.com/member.php...o&userid=26508
View this thread: http://www.excelforum.com/showthread...hreadid=479277