Steema Central

After generating a TeeChart plot in Excel, if I want to edit it (such as changing line colors) I need to go into Design mode.

When I go into design mode, the chart area blanks out. Yes I can make all the change I want, but I can't see the results until I get out of Design Mode.

Is this normal behavior? Is there a property setting so that TeeCharts will behave like Excel charts and let the user see the plot while changes are being made?

Thanks.

I just answered my own question:

I created a subroutine like this:

Sub editChart()
Shapes("TChart1").Select
Selection.Verb Verb:=xlPrimary
End Sub

When I attach it to a button, I press the button and the chart is selected and the editor window opens. I can make my edits while viewing the changes as the plot is not blanked out since I'm not in edit mode.