Creating Bubble Chart in Microsoft Access Reports

[Tamrak]

I'm attempting to create a bubble chart in a report using the Chart Wizard. I've created these in Excel with no trouble, but the Access Chart Wizard is stumping me. The format of the table I'm attempting reference in the Wizard is as follows along with where I would like them to appear in the chart:

Tier (Series Labels) l Field X (X-axis values) l Field Y (Y-axis values) l Bubble (Size of bubbles)

The screen asking me how I want to lay out my data is where the trouble begins. Could someone help me figure out where I would drag/drop those 4 fields in the Data/Series fields of the Chart Wizard to get the desired results or help me with a formula I could use for the Record Source?

The graph always displays the dummy data (south, east, north, west), which I do not understand why it could not display the real data from my record source (table.)


Thank you in advance for your time!

 

[dhookom]

The data comes from the row source. I just created a bubble chart using the Wizard (which doesn't really have a clue). I then changed the row source to:

SELECT tblForBubbleChart.X, tblForBubbleChart.Y, tblForBubbleChart.BubbleSize FROM tblForBubbleChart;

I copied the datasheet view of the records and then opened the chart control in design. I deleted the existing datasheet values and pasted in the results of the row source. You then may need to change around the "By Row" or "By Column" attribute of the Chart control.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Tamrak]

Thank you for your response. I am still learning about the chart.

1. How can I embed the series labels into the chart? Look like the chart does not recognize the series label. For example, I would like to label each bubble with the name appeared in my first column.

If I could not label anything, at least, I should be able to create a legend (name) for the users to read.

2. In Excel, I can define the series label. I could not find anything in Access.

Thanks again for your response. It is great to learn this one from you. All suggestions are welcome. Thanks again.


p.s. Can you suggest any web sites that have knowledge base regarding this topic? I have been searching via Google / Yahoo and could not locate anything. Microsoft site did not provide much information either. Thanks.

 

[dhookom]

I am at a loss on how to get labels to appear. Help refers to 3 columns when you really need 4 if you want to include a label for each bubble.

You might want to try googling for bubble chart help. There is help file installed on your PC:

C:\Program Files\Microsoft Office\Office10\1033\VBAGR10.CHM

You may have to use code to set the properties. I usually set up a barebones chart in Excel, turn on the macro recorder, set some properties that I want to set in Access, stop the recorder, find and copy the code into the On Format event of the report section containing the chart. This will take some tweaking to reference your chart control.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]