Search found 21 matches

by Productivity Guy
Fri Nov 16, 2007 6:37 am
Forum: ActiveX
Topic: No constant radius in Bubble Chart?
Replies: 4
Views: 6449

OK. I THINK I got it. In my tests (though not comprehensive), the radius is based on the Y axis. Changing the X axis seems to have no effect. I FINALLY think I understand what a unit is. I kept getting confused by thinking it was a RATIO of the scale. But, it's not. It's just like you said: a unit. ...
by Productivity Guy
Thu Nov 15, 2007 9:59 pm
Forum: ActiveX
Topic: No constant radius in Bubble Chart?
Replies: 4
Views: 6449

I'm still struggling with the concept of the radius being in "Units" of the axes scales. Which axis? If X is 1 to 50 and Y is 1 to 100, and radius is 10, which scale determines the bubble size? Is it 1/20 of X or 1/10 of Y? Or, is is something else, entirely? In playing with your sample code, I stil...
by Productivity Guy
Thu Nov 15, 2007 12:26 am
Forum: ActiveX
Topic: No constant radius in Bubble Chart?
Replies: 4
Views: 6449

No constant radius in Bubble Chart?

I see from another post that: However, the chart is scaled according to X and Y values. So when the bubbles are drawn, if they have very small radius compared to the axes scales they won't be seen. So, there's no way of having a constant bubble radius, independent of the chart scale? That seems like...
by Productivity Guy
Wed Nov 14, 2007 6:06 pm
Forum: ActiveX
Topic: AntiAlias breaks MouseClick?
Replies: 2
Views: 4432

Ahh. Yes, I'm using V7. I'll check to see how much the upgrade is.

EDIT: I've just upgraded. Thanks for your help.
by Productivity Guy
Tue Nov 13, 2007 9:14 pm
Forum: ActiveX
Topic: AntiAlias breaks MouseClick?
Replies: 2
Views: 4432

AntiAlias breaks MouseClick?

I have a bubble chart and I want to display bubble labels on click. I managed to put together some code that works --- BUT it only works with antialias turned off. (And, the bubbles look VERY bad without antialiasing. Here's the code: Set rs = GetBubbleRS("Unit", "CEO", "") With TChart1 .Aspect.View...
by Productivity Guy
Tue Nov 13, 2007 7:02 pm
Forum: ActiveX
Topic: Bubble Chart Labels
Replies: 3
Views: 5415

I found it:

TChart1.Series(SeriesIndex).PointLabel(ValueIndex)
by Productivity Guy
Tue Nov 13, 2007 6:53 pm
Forum: ActiveX
Topic: Object Model Overview?
Replies: 1
Views: 3581

Object Model Overview?

I'm an experienced Access VBA programmer, but I'm really struggling with the object model of TeeChart v7 ActiveX. Is there an overview, somewhere, that explains the object hierarchy I'm having a real hard time figuring out what object, properties, and methods to use at various times. I've gone throu...
by Productivity Guy
Tue Nov 13, 2007 6:46 pm
Forum: ActiveX
Topic: Bubble Chart Labels
Replies: 3
Views: 5415

Thanks. That works. Now, I just can't figure out how to get access to the Label property when clicking the bubble.
by Productivity Guy
Thu Nov 08, 2007 6:05 pm
Forum: ActiveX
Topic: Bubble Chart Labels
Replies: 3
Views: 5415

Bubble Chart Labels

In another thread, I found this: The AddBubble method appends a new Bubble point to the Series Points List. The Bubble point is assigned to be at AX,AY coordinates and have ARadius, Label and Color parameters. The Label parameter is used to draw Axis Labels, Bubble Marks and Legend. So, the Label pa...
by Productivity Guy
Thu Nov 08, 2007 5:04 pm
Forum: ActiveX
Topic: Bubble Chart Click
Replies: 4
Views: 8007

Hmmmm.... I created a brand new bubble chart on a brand new form, and YOUR sample code works. (I only tested the Click sample, so far.) So, now I have to figure out what's different about MY chart that's keeping the click from working. Do you notice anything? Could it be that my Y axis values are al...
by Productivity Guy
Thu Nov 08, 2007 4:56 pm
Forum: ActiveX
Topic: Bubble Chart Click
Replies: 4
Views: 8007

Well, here's my problem. I can't even get a bubble to recognize the click. Private Sub TChart0_OnClickSeries(ByVal SeriesIndex As Long, ByVal ValueIndex As Long, ByVal Button As Long, ByVal Shift As Long, ByVal X As Long, ByVal Y As Long) MsgBox "Clicked" End Sub Does not work when I click on a bubb...
by Productivity Guy
Thu Nov 08, 2007 6:01 am
Forum: ActiveX
Topic: Bubble Chart Click
Replies: 4
Views: 8007

Bubble Chart Click

I've tried to follow the examples about using OnSeriesClick and OnMouseMove with a Bubble chart to display bubble values, to no avail. I can't even get the mouse events to react to the bubbles at all. The closest I've come is to get responses as I click or move the mouse along the X axis. Is this a ...
by Productivity Guy
Mon Apr 04, 2005 11:24 pm
Forum: ActiveX
Topic: Legend showing all values
Replies: 1
Views: 3891

Solved

I found it.

The default setting for the Legend is Automatic, which does exactly what I described.

To force it to always just show the Series name:

TChart.Legend.LegendStyle = lsSeries

-Keith Price
by Productivity Guy
Mon Apr 04, 2005 11:15 pm
Forum: ActiveX
Topic: Legend showing all values
Replies: 1
Views: 3891

Legend showing all values

I have a chart with the Legend showing. I add all series, programatically. When I have 2 or more series, just the series names show in the legend (as it should be). But, when there's only 1 series, the legend is showing all the value points in the series. I want it to just show the series name. How ...
by Productivity Guy
Thu Mar 31, 2005 10:30 pm
Forum: ActiveX
Topic: Chart won't resize in Access
Replies: 1
Views: 3863

Chart won't resize in Access

Once I place a Tchart in an Access form, and run and save it... I can't seem to change the size in design view. It will let me drag to a new size, but when it runs, it goes back to the original size. In the Properties window, if I change the Height or Width property, the value goes back to the previ...