Thanks Pep for the help with the centering of the Labels! Here's another question, how do I fix the size of the Bubbles? I can fix the size of the Diamond in a line chart, but I can't seem to see how to fix the bubbles on the chart, 'QuadrantChart.Legend.Symbol.WidthUnits = lcsPixels 'QuadrantChart....

Hey Guys, I'm building a Bubble chart, my labels are simple numbers 1, 2, 3, etc. they are showing up in the top of the symbol / bubble, is there a way to center the numbers? No is an acceptable answer :D Here is the code I'm using, i is the number / label. adoRs.MoveFirst Do Until adoRs.EOF With Qu...

Hey Guys, I'm building a Bubble chart, my labels are simple numbers 1, 2, 3, etc. they are showing up in the top of the symbol / bubble, is there a way to center the numbers? Here is the code I'm using, i is the number / label. [ adoRs.MoveFirst Do Until adoRs.EOF With QuadrantChart.Series(1).asBubb...

Pep,

I got the code in and saw some results, however the last one still is oblong not round?

Any other ideas?

Mike

Christopher, You asked for a snippet, the last bubble in the legend is flattened? Here is the snippet of code: [i = 1 adoRs.MoveFirst Do Until adoRs.EOF With QuadrantChart.Series(1).asBubble .AddBubble adoRs.Fields(3).Value, adoRs.Fields(2).Value, 0.8, i, RGB(ChartColorRed(i), ChartColorGreen(i), Ch...

Christopher, thank you worked fine!!

BigMike

Any ideas on why the complier would say "Axis = Bottom" below is not defined, it works under V6. Where I'm using it was created using V7 so there should be no conversion, Right? [With QuadrantChart.Tools .Items(0).Active = True With .Tools.Items(0).asColorband .Axis = Bottom .Brush.Style = bsSolid ....

When building a Bubble Chart and using bubbles in the legend, the last bubble shows up flattened, as if there wasn't enough room in the line for it. All the other bubbles on the same line are fine it is only the last one to enter the legend that has the problem.

Any Ideas?

I went to the sample V7 Access Chart and clicked on the teChart -- it darken, then I closed the application and the save the change. When you run the report again the chart is gone!!!

WHY???

BigMike
mcurry@eliant.com

We are working with MS Access building a report using Report Design, We add a Chart V7 and we save the report close Access and when we come back to the report modify it and resave and when we reopen it we get: MS Office Access There is no Object in this Control And your Chart is gone all that is let...

When I copy a report from one Access database where it works to another Access database the data does not display. It appears the loading of the appropriate .ocx is not enough. What else must be done??

Christopher, I did not make my request clear. What we are doing is running the report within Access 2003, created within Access 2003 Could you please show us an example of a report running / created within Access 2003. Also, I copied your example into an Access 2003 database, compiled it with all th...

We have moved our application into Access 2003. What we are experiencing is that none of the data coming form tables / queries is being displayed.

Are there any configuration considerations for Access 2003?