Chart Disappeared

[Coolboy55]

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?

 

[Tushar Mehta]

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

 

[Coolboy55]

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