How to add new series to an existing chart

I have a report in ms/access 2013  that has a number of charts. Now I want to add a new series to the charts (the new series is on the new source table that was not previously ther) How do I do it?

I am attaching the database (a fairly simple one). the report is APP I chart Bissau, and the new series is "Guinea-Bissau"

can anyone help?
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.

Eric ShermanAccountant/DeveloperCommented:
No database uploaded??  Try to upload it again.

João serras-pereiraAuthor Commented:
Eric ShermanAccountant/DeveloperCommented:
The Series in the first graph comes from the field [Study Region Code] in the query [Q_Summary_Notes).  There are only two unique region codes (ECOWAS and EU-28) in this query.  Where is Guinea-Bissau???

Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

João serras-pereiraAuthor Commented:
You are right!

Actually they should be sourced from a different Table (this was a quick dirty job...).  

I had forgotten that! Now that I have found the problem I do not find the means to change the source Table to it! Do I need to completely redo the charts?.
Eric ShermanAccountant/DeveloperCommented:
>>>>> Do I need to completely redo the charts?.<<<<<

No, not really.  Just open your report in design mode, right click on the chart, go to properties >>> data then change the row source for the chart.  See picture below.



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:
Thanks a lot. Let's close the problem. The row source is quite complicated anyway and I tried without success... So I decided to redo the chart - that's the quickest way right now. For the future I'll plan better.
Jeffrey CoachmanMIS LiasonCommented: "Guinea-Bissau", is a new "Study Region Code"?

As far as I can tell, all your charts reference "Study Region Code" as the Group By field.
So if you have the Study Region Code for "Guinea-Bissau", in the source data, it will be included in the chart.

In other words, as you add new "Study Regions", there is no need to include a new series in this type of chart, the new series will be created by the Charts row source each time it see a different "Study Region"

For example, in your charts, the only Study Region codes in the charts rowsource are: EU-28 and ECOWAS
But I do see "Guinea-Bissau" in the table: T_Summary_GNB,
But not in the rowsource for any of the charts.

This looks like a function of your Joins (perhaps "Guinea-Bissau", does not have any matches in the other table?)

In any event that is what I see.
If you see "Guinea-Bissau" in the charts row source, it will be included in the chart.
No it is up to you to determine why "Guinea-Bissau" is not in any of the rowsources for the charts...

João serras-pereiraAuthor Commented:
Hi Jeff -
Well... this a perfect example of wrongdoing on my part (but not only). Actually, I wanted to chart some figures from the world bank as they do not produce the charts and data selections that I wanted.

So I've downloaded their tables, to find out that they are pre-formatted as excel spreadsheets, with merges cells and, in that form, useless.

So (it as a real pain), I decided to have a single table with all data, from which I would chart whatever I wanted; but this was done with given a thought on what  I really wanted.

The I decided that I wanted to compare 2 regions (ECOWAS/EU-28) and it was fine. Charts and comments were produced and the report completed.

But, after delivery of the report, it was found that it would be extremely useful to keep all charts as they were using the ECOWAS/EU-28 series and, additionally, plot a selected country against them. Having forgot which were the actual sources for the charts, I had no solution for that, so, said to myself: gee... if I just past a country's data (e.g. "Guinea-Bissau") on the top of the query that contains the series as a new series it would work.

It didn't in the beginning and as I tried to change the complicated (for me) source of the charts, I did not succeed (always stating that was a missing "value" field. That was when I quitted and decided to redo the charts. Now it is working and learned again (and again and again) my most precious and repeatedly forgotten lesson: better aim first and shoot after than the opposite.

Anyway, for my current goals, the aesthetic charting capabilities of Access are too limited and cumbersome to use, so I am trying to locate a good charting solution that may be able to produce this type of reports mixing charts, text, computation, etc. from a set of tables.

For that I am thinking on Filemaker Pro. What do you think?

Kindest regards

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.