Search found 16 matches

by dastrw
Tue Nov 27, 2007 11:43 pm
Forum: ActiveX
Topic: Programmatically add active TeeChart Object in Excel
Replies: 1
Views: 3960

Programmatically add active TeeChart Object in Excel

The two Excel examples you have included do the following: 1) Work with an active TeeChart that has already been manually added 2) Programmatically add a passive TeeChart Could you give me some sample code for programmatically adding an active TeeChart to an Excel worksheet? I would like to be able ...
by dastrw
Mon Nov 19, 2007 6:41 pm
Forum: ActiveX
Topic: TeeChart Blank During Edit
Replies: 1
Views: 3489

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 ...
by dastrw
Mon Nov 19, 2007 6:30 pm
Forum: ActiveX
Topic: TeeChart Blank During Edit
Replies: 1
Views: 3489

TeeChart Blank During Edit

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 behavi...
by dastrw
Mon Nov 19, 2007 6:06 pm
Forum: ActiveX
Topic: Excel Range as Datasource
Replies: 5
Views: 7486

The reason we purchased TeeChart was that we were expecting that in all ways it would be superior to Excel charting. In Excel you can associate a range of cells with a chart. Then if a person changes the data in those cells, the corresponding points change instantly in the chart. I was hoping that T...
by dastrw
Mon Nov 12, 2007 6:10 pm
Forum: ActiveX
Topic: Smith Charts
Replies: 5
Views: 8016

I can't see the Smith Chart help files because I don't have TeeChartx7.hlp. Please send me a copy, but change the extension so that my company's firewall won't strip it out of the email.
by dastrw
Mon Nov 12, 2007 5:18 pm
Forum: ActiveX
Topic: ActiveX v8 samples reference v7 control
Replies: 7
Views: 9888

Someone at Steema already tried to send me the v7 support files, but they got stripped out by our corporate firewall.

Please send me the support file, but change the 'zip' extension to something else like 'txt' so that the attachment won't get stripped out.

Thank you.
by dastrw
Fri Nov 09, 2007 3:51 pm
Forum: ActiveX
Topic: Excel Range as Datasource
Replies: 5
Views: 7486

Sorry, but the last time I subscribed to that newsgroup my computer got screwed up and I had to re-image it. Here is the code from your own example 'TeeChart Pro Inserted into Excel.xls': For t = 2 To 6 TChart1.Series(0).Add SampleData.Item(t, 2), SampleData.Item(t, 1), clTeeColor Next Notice how yo...
by dastrw
Fri Nov 09, 2007 12:22 am
Forum: ActiveX
Topic: Copy/Paste TeeChart From Excel to PowerPoint
Replies: 2
Views: 4220

Thanks. The export/import works great!

Somehow I was able to cut-and-paste from Excel to PowerPoint, but it only worked some of the time and for no apparent reason.

This is a much more dependable method.
by dastrw
Thu Nov 08, 2007 11:53 pm
Forum: ActiveX
Topic: TeeChart Object Name in Excel
Replies: 2
Views: 4638

If I put my Excel worksheet into Design Mode and then I select the TeeChart object, then the object name appears in the upper-left text field that normally shows the current range or defined name. I can rename the object by typing over TChart1 to get something that makes more sense. This is still ki...
by dastrw
Thu Nov 08, 2007 5:39 pm
Forum: ActiveX
Topic: Smith Charts
Replies: 5
Views: 8016

Is there documentation on which chart/series/axes/etc. properties have an effect on the display of Smith Charts?

Or do I need to spend a day or two trying every combination to figure this out myself?
by dastrw
Thu Nov 08, 2007 5:36 pm
Forum: ActiveX
Topic: ActiveX v8 samples reference v7 control
Replies: 7
Views: 9888

Sorry I didn't mention it in my earlier post, but the v7 references that are causing me problems are the ones in the v8 help documents. So when I try to work through the user guides and help documents I am constantly running into message boxes telling me that TeeChart can't find the v7 files and wou...
by dastrw
Thu Nov 08, 2007 2:47 am
Forum: ActiveX
Topic: Copy/Paste TeeChart From Excel to PowerPoint
Replies: 2
Views: 4220

Copy/Paste TeeChart From Excel to PowerPoint

I would like to be able to manually copy and paste a TeeChart I created in Excel into a PowerPoint presentation. I can only select the TeeChart object in Excel Design Mode. If I copy and paste this object then there is no chart showing in PowerPoint. I can't select the TeeChart object when Excel is ...
by dastrw
Thu Nov 08, 2007 2:38 am
Forum: ActiveX
Topic: ActiveX v8 samples reference v7 control
Replies: 7
Views: 9888

What if we didn't upgrade from v7, but instead got v8 new?
by dastrw
Thu Nov 08, 2007 12:59 am
Forum: ActiveX
Topic: Smith Charts
Replies: 5
Views: 8016

Smith Charts

I am working with the TeeChart Smith Charts for the first time. I was wondering where I can find out which properties to set which way in order to get the Smith Charts to look like typical Smith Charts, i.e. 1) Showing angle (in radians or degree) rather than the imaginary part of the impedance arou...
by dastrw
Wed Nov 07, 2007 9:08 pm
Forum: ActiveX
Topic: Excel Range as Datasource
Replies: 5
Views: 7486

Excel Range as Datasource

Is there a way to tell a chart to get its series data from a range in the current Excel workbook? I can choose Excel from the list of DataSources, but then it wants to open that workbook and it won't let me choose the current workbook. The examples require using Macros to populate the series point-b...