Grouped Charts Issue

[Trek9635]

Hello everyone, my first post here. I am pretty intermediate with access but generally only use it for queries to create reports in excel. This is my first time working with charts inside of an access report. I have a single table with various fields I would like to create numerous line charts. I created a group by the data field I would like the various reports created by and created the chart in the group header to no avail. I only get one blank chart with only the title, not the duplicated charts with data.

Here is a sample of the table fields. I am trying to get various line charts showing average days for each month by Area

Ex.
AREA Month Year Financial1 Financial2 Financial3 Financial4 Average Days


PPS 01 2014 xxx xxx xxx xxx 8
PPS 02 2014 xxx xxx xxx xxx 6.5
PPS 03 2014 xxx xxx xxx xxx 11
XYZ 01 2014 xxx xxx xxx xxx 9
XYZ 02 2014 xxx xxx xxx xxx 13
QRS 01 2014 xxx xxx xxx xxx 13

I have both the master/child link set to area.
TRANSFORM Sum[Average Days] as SUM[Average Days] SELECT [Month] FROM [Sheet1] GROUP BY [Month] Pivot [AREA];

Any help or insight would be great as I not a pro at these charts. Just not sure why it is not working!

[June7]

Did you use Query Builder to construct SQL? Why doesn't the posted SQL have parens for the Sum() function? And the alias field name uses [] in wrong place.

TRANSFORM Sum([Average Days]) AS [SUMAverage Days] SELECT [Month] FROM [Sheet1] GROUP BY [Month] Pivot [AREA];

Month and Year are reserved words. Should not use reserved words as names. http://allenbrowne.com/AppIssueBadWord.html

[Trek9635]

No I just retyped what it showed in access. I used the chart wizard. The [] in the wrong place is likely just me typing it wrong. Where do you believe the [] should be?

[June7]

As shown in my post.

Is this a multi-year db? If so, should probably include the Year in the grouping.

[Trek9635]

Nope, this is only a 2014 table. Thank you. Should the chart be under the grouped header?

[June7]

I don't know your db so can't really answer that. I have a report with graph in group section and it works.

None of my graphs use SQL statement generated by the graph wizard and none are a CROSSTAB query.

I analyze graph issues best when I can work with db and data. If you want to provide, follow instructions at bottom of my post.

[Trek9635]

I will try your suggestion tomorrow and let you know. I appreciate the help. I do know that If I enter txt before the master key the parameter prompt pops up and if I enter the AREA the chart populates perfectly, but again only for that one area, not the 6 different once I am looking for.

[Trek9635]

Even with the source exactly how you specified the charts are still blank. The database is just a simple excel table I exported in. 119 rows.

[June7]

As suggested, provide db.