I know this type of graphing can be done in Excel, but I have taken my data to Access in an attempt to simplify/automate the production of what could turn out to be hundreds of charts requiring different titles etc... I'm not that sophisticated w/Access and do not know VB at all, but have spent a LOT of time trying to figure this one out on my own to no avail!! Any words of wisdom would be appreciated.

I need to have a stacked bar graph display 3 series of data with each series containing 3 fields/pieces of data. This information is all contained in one table, with each record holding the 9 fields needed for the graph.

Searching various boards like this one I figured out how to create a stacked bar chart (altering the 'chart type' after using one of the choices provided by the wizard in Access 2k), but not how to set up seperate series in this situation.

I tried to use a work-around by spliting each of my records into 3 records with the same ID, but am having a VERY strange problem that has the same chart showing up with different records (eg. the chart for ID #1 would show with data from ID #1 and ID #2, but ID's #3-10 would be fine, with other duplications further into the report). After doing everything I can figure with that method, I started to explore the multi-series from one record approach again, but find that my weakness w/SQL syntax is giving me real grief.

It would seem that you might be able to define multiple series in the 'Row Source' property using SQL, but I just can't figure it out.

Please just tell me that there is an easy way to do this and that I am just a slow newbie!

Help!!!!

Thanks,

Jacques