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

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

It has nothing to do with the macro, as I've since found out. I
rebooted the machine, opened up a new workbook in Excel, and threw
together some random data and created a chart. Same problem. The
chart shows up as a little sliver in the middle of the page, no matter
what I set my zoom at. It seems to be some sort of global option that
is skewed. I tried your recommendation, but it was already set at Show
All. What could possibly be causing my chart not to show properly??


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