Avatar of João serras-pereira
João serras-pereiraFlag for Portugal asked on

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)
Microsoft Access

Avatar of undefined
Last Comment
João serras-pereira

8/22/2022 - Mon
IrogSinta

You forgot to attach your database.
ASKER
João serras-pereira

ASKER
João serras-pereira

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
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
IrogSinta

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
João serras-pereira

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!
IrogSinta

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
ASKER
João serras-pereira

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.......
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.