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