Click on chart to view it otherwise greyed out

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been sent a workbook that contains a number of charts. when the
workbook opens the charts are not visible, but are "greyed out". I have to
click on a chart to view it. As soon as I click away from the chart it is
hidden again.

The source data is created using the offset function and the parameters for
this function are selected using form combo boxes.

Please can anyone suggest how I can make the charts visible at all times

Thanks

Carl
 
Hi,

Sounds like you have objects set to show place holders.
To show all use the menu Tools > Options. On the View tab is a section
for Objects. Check the Show all option.

Cheers
Andy
 
Thank you Thank You Thank You....
This is a great tool .....your are llife savers...
Steve
 
Back
Top