Search found 11 matches
- Wed Oct 09, 2013 10:32 pm
- Forum: ActiveX
- Topic: Change tool | Rectangle text in code
- Replies: 2
- Views: 7889
Re: Change tool | Rectangle text in code
Nevermind. It DOES work. I just had to close the form and run fresh. Just going from design view to form view didn't seem to want to update the text.
- Wed Oct 09, 2013 10:20 pm
- Forum: ActiveX
- Topic: Change tool | Rectangle text in code
- Replies: 2
- Views: 7889
Change tool | Rectangle text in code
I added 3 rectangles to my chart using the UI. Now, I want to modify the text at runtime. THIS doesn't seem to do anything: With TChart_3MoScheduled .Tools.Items(0).asRectangle.Text = "$1,000" .Tools.Items(1).asRectangle.Text = "$10,000" .Tools.Items(2).asRectangle.Text = "$100,000" End With I know ...
- Wed Oct 09, 2013 10:09 pm
- Forum: ActiveX
- Topic: How to show intellisense in MS Access?
- Replies: 2
- Views: 7495
Re: How to show intellisense in MS Access?
This works:
Code: Select all
Dim cht As TeeChart[b].TChart[/b]
Set cht = New TeeChart
- Wed Oct 09, 2013 10:05 pm
- Forum: ActiveX
- Topic: How to show intellisense in MS Access?
- Replies: 2
- Views: 7495
How to show intellisense in MS Access?
I'm running TeeChart in MS Access. The charts work just fine.
But, I can't figure out how to get Intellisense to work in my code. I tried
But, that doesn't give it to me when I type "cht.".
Any help?
But, I can't figure out how to get Intellisense to work in my code. I tried
Code: Select all
Dim cht As TeeChart
Set cht = New TeeChart
Any help?
- Wed Oct 09, 2013 9:26 pm
- Forum: ActiveX
- Topic: Custom Text - Alignment
- Replies: 1
- Views: 6094
Custom Text - Alignment
I'm using this code to add custom text to my chart: .Tools.Add tcAnnotate With .Tools.Items(ctr - 1) .Active = True With .asAnnotation .Top = (intRecTop + 5) + (intTextHeight * (ctr - 1)) .Left = intRecLeft With .Shape .TextAlignment = taRightJustify .Transparent = True .Transparency = 100 .ShapeSty...
- Sat Aug 17, 2013 8:48 pm
- Forum: ActiveX
- Topic: Change position of Legend?
- Replies: 2
- Views: 7636
Re: Change position of Legend?
ANSWER: I was able to change the Legend position in Edit Chart Settings | Legend.
In order to make it OVERLAY the chart, rather than outside it, I had to use Custom.
In order to make it OVERLAY the chart, rather than outside it, I had to use Custom.
- Sat Aug 17, 2013 8:45 pm
- Forum: ActiveX
- Topic: Change position of Legend?
- Replies: 2
- Views: 7636
Change position of Legend?
How can I set the position of the Legend via settings and also via code?
- Sat Aug 17, 2013 6:57 pm
- Forum: ActiveX
- Topic: Change background color of MarkText?
- Replies: 2
- Views: 7571
Re: Change background color of MarkText?
I found how to do it via Settings in Edit Chart:
Select Series
Marks
Format
Color
Note: Gradient settings appear to override Format Color.
Select Series
Marks
Format
Color
Note: Gradient settings appear to override Format Color.
- Sat Aug 17, 2013 6:43 pm
- Forum: ActiveX
- Topic: Change background color of MarkText?
- Replies: 2
- Views: 7571
Change background color of MarkText?
How can I change the background color of the MarkText box? The only way I've found, so far, is to use Gradient, but I want a solid color. I suppose I could probably set all the parts of the gradient to the same color, but it seems there should be a way to just set the background color. How can I do ...
- Sat Aug 17, 2013 6:41 pm
- Forum: ActiveX
- Topic: How to change MarkText POSITION?
- Replies: 1
- Views: 5861
How to change MarkText POSITION?
My MarkText boxes on a line chart are covering the lines. How can I change their position?
In THIS case, I'm only showing (and wanting to change the position of) the final data point.
In THIS case, I'm only showing (and wanting to change the position of) the final data point.
- Sat Aug 17, 2013 6:39 pm
- Forum: ActiveX
- Topic: How to identify the LAST point in a line chart?
- Replies: 1
- Views: 5828
How to identify the LAST point in a line chart?
I want to display the value in a line chart for only the last data point.
So far, I've discovered the TChart_SalesAndBacklog_OnGetSeriesMark event, but how do I identify the FINAL data point so I can set the MarkText for it?
OR, is there a better way to do what I'm trying to accomplish?
So far, I've discovered the TChart_SalesAndBacklog_OnGetSeriesMark event, but how do I identify the FINAL data point so I can set the MarkText for it?
OR, is there a better way to do what I'm trying to accomplish?