Charts on MS/ACCESS 2012

I am exploring a database I have of economic indicators.
It has a fairly simple structure (1 TABLE... and a twin of it that was used in a first version).

Now I am just willing to extract a few charts from selected records.

I have already developed a crosstab query and it work perfect, report REGION / Indicator / Year Average.

Now all I want is to chart this (1 chart per indicator, the Y axis is the REGION and the X axis, the Years value (average for all countries in a region)

The table contains the COUNTRY / YEAR / REGION / INDICATOR /VALUE, but, no matter how, it won't produce the chart.
Hou do I do it?

(I am attaching the database, just in case)
João serras-pereiraAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

IrogSintaCommented:
You forgot to attach your database.
0
João serras-pereiraAuthor Commented:
0
João serras-pereiraAuthor Commented:
Just let me add a bit.
My final idea is to have a 50 page report, 1 chart per "Indicator Name"
each chart plots 2 series: one per "Study Region Code" (Y-AXIS)  against the values I need (average, total, stdev,or some calculated in between)  etc... for the 1960..2012 years in X-AXIS.

My problem is that I am using the graphic object and it always does not link to a source.

I am attaching again the database with the new failing report
DissertDB-03.zip
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

IrogSintaCommented:
How are you populating the table WB?  The reason I'm asking is because this table is not Normalized.  Is this imported from a spreadsheet and if so, is this something you intend to keep doing at certain intervals or is this a one time transfer and you intend to use the database from then on?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
João serras-pereiraAuthor Commented:
Hi IROGSINTA -

I have found the problem; it was a major misunderstanding from me of ms/access functionality. It looks that it is ate least one version below ms/excel...

Now answering to yor question: actually I am not using WB table but the Integrated_Data table thas is normalized.

Anyway, you already helped me quite a lot in the past, so I am putting all the points to your answer.

I am still struggling with formats inside the chart but it is coming and if you want to check I'll upload the database again.
Thanks a lot!
0
IrogSintaCommented:
Actually neither table is normalized.  If you see repeating fields in your table, that's a big hint.  For this to be normalized, you would have one table for CountryName, CountryCode, and StudyRegionCode, another table for IndicatorName, and IndicatorShortName, and lastly your table of Years and Values.  

That's why I wanted to find out if this was a one time deal or not.  If it is and you don't intend to add anymore data or re-import then normalizing may not be such a big deal.

What's interesting is that you run queries to create your Integrated table and then use that to create a crosstab for your report.  The thing is, your WB table is already set up like a crosstab.  
Here's a revised version showing just the wb_averages report using a query based off your WB table.
DissertDB-rev.accdb
0
João serras-pereiraAuthor Commented:
Thanks a lot!!!!!

You are right - this is a one time job to get things quick and dirty. And thanks for the hint. I'll manage from that.

Now I am on to chart and comment charts.......
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.