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?
Eric ShermanConnect With a Mentor Accountant/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.


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

João serras-pereiraAuthor Commented:
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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???

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?.
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

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.