Search found 16 matches
- Tue Nov 27, 2007 11:43 pm
- Forum: ActiveX
- Topic: Programmatically add active TeeChart Object in Excel
- Replies: 1
- Views: 4115
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 ...
- Mon Nov 19, 2007 6:41 pm
- Forum: ActiveX
- Topic: TeeChart Blank During Edit
- Replies: 1
- Views: 3613
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 ...
- Mon Nov 19, 2007 6:30 pm
- Forum: ActiveX
- Topic: TeeChart Blank During Edit
- Replies: 1
- Views: 3613
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...
- Mon Nov 19, 2007 6:06 pm
- Forum: ActiveX
- Topic: Excel Range as Datasource
- Replies: 5
- Views: 7843
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...
- Mon Nov 12, 2007 6:10 pm
- Forum: ActiveX
- Topic: Smith Charts
- Replies: 5
- Views: 8429
- Mon Nov 12, 2007 5:18 pm
- Forum: ActiveX
- Topic: ActiveX v8 samples reference v7 control
- Replies: 7
- Views: 10440
- Fri Nov 09, 2007 3:51 pm
- Forum: ActiveX
- Topic: Excel Range as Datasource
- Replies: 5
- Views: 7843
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...
- Fri Nov 09, 2007 12:22 am
- Forum: ActiveX
- Topic: Copy/Paste TeeChart From Excel to PowerPoint
- Replies: 2
- Views: 4419
- Thu Nov 08, 2007 11:53 pm
- Forum: ActiveX
- Topic: TeeChart Object Name in Excel
- Replies: 2
- Views: 4809
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...
- Thu Nov 08, 2007 5:39 pm
- Forum: ActiveX
- Topic: Smith Charts
- Replies: 5
- Views: 8429
- Thu Nov 08, 2007 5:36 pm
- Forum: ActiveX
- Topic: ActiveX v8 samples reference v7 control
- Replies: 7
- Views: 10440
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...
- Thu Nov 08, 2007 2:47 am
- Forum: ActiveX
- Topic: Copy/Paste TeeChart From Excel to PowerPoint
- Replies: 2
- Views: 4419
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 ...
- Thu Nov 08, 2007 2:38 am
- Forum: ActiveX
- Topic: ActiveX v8 samples reference v7 control
- Replies: 7
- Views: 10440
- Thu Nov 08, 2007 12:59 am
- Forum: ActiveX
- Topic: Smith Charts
- Replies: 5
- Views: 8429
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...
- Wed Nov 07, 2007 9:08 pm
- Forum: ActiveX
- Topic: Excel Range as Datasource
- Replies: 5
- Views: 7843
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...