Search found 11 matches

by Kaprice
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.
by Kaprice
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 ...
by Kaprice
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
by Kaprice
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

Code: Select all

    
  Dim cht As TeeChart
    
  Set cht = New TeeChart
But, that doesn't give it to me when I type "cht.".

Any help?
by Kaprice
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...
by Kaprice
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.
by Kaprice
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?
by Kaprice
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.
by Kaprice
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 ...
by Kaprice
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.
by Kaprice
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?