I am putting together a business case model that requires a number of
charts/graphs. A few days ago the charts, which I had embedded within the
relevant tabs, were no longer visible when clicking on the relevant tab.
They appear as grey rectangles until clicked, when the chart then becomes
visible. I have tried deleting and creating new charts but the same problem
occurs.

What can I do to stop this from happening. I do not wish to recreate the
workbook as it took weeks to create.

Hi,

Go Tools Options View. Set Objects Show All.

Cheers
Andy

Absurd Jewel wrote:
I am putting together a business case model that requires a number of
charts/graphs. A few days ago the charts, which I had embedded within the
relevant tabs, were no longer visible when clicking on the relevant tab.
They appear as grey rectangles until clicked, when the chart then becomes
visible. I have tried deleting and creating new charts but the same problem
occurs.

What can I do to stop this from happening. I do not wish to recreate the
workbook as it took weeks to create.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks! I must have accidently changed the setting somehow.

"Andy Pope" wrote:

Hi,

Go Tools Options View. Set Objects Show All.

Cheers
Andy

Absurd Jewel wrote:
I am putting together a business case model that requires a number of
charts/graphs. A few days ago the charts, which I had embedded within the
relevant tabs, were no longer visible when clicking on the relevant tab.
They appear as grey rectangles until clicked, when the chart then becomes
visible. I have tried deleting and creating new charts but the same problem
occurs.

What can I do to stop this from happening. I do not wish to recreate the
workbook as it took weeks to create.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info