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.
TeeChart Blank During Edit
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.
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.