Chart prints as greyed out rectangle

[Satyagrahi]

This problem popped up a couple of months ago in an existing workbook
and has stumped several people.

All the charts in this workbook (one chart on each of four worksheets)
appear normally IF you have selected them. If you click on any other
cell on the sheet, the chart immediately changes to a grey rectangle,
unreadable. Also, the charts print as grey rectangles.

If you totally delete the chart and recreate it, the some problem is
immediately in effect.

I'm sure this is some configuration feature, perhaps obscure, perhaps
so obvious that we can't see it. Any suggestions?

 

[Debra Dalgleish]

From the Tools menu, choose Options.

This problem popped up a couple of months ago in an existing workbook
and has stumped several people.

All the charts in this workbook (one chart on each of four worksheets)
appear normally IF you have selected them. If you click on any other
cell on the sheet, the chart immediately changes to a grey rectangle,
unreadable. Also, the charts print as grey rectangles.

If you totally delete the chart and recreate it, the some problem is
immediately in effect.

I'm sure this is some configuration feature, perhaps obscure, perhaps
so obvious that we can't see it. Any suggestions?

 

[Satyagrahi]

That did it, Debra. Thank you so much.