Area Chart showing percentage?

[rcoutts]

I'm a newbie that created an Area Chart using the Graph Wizard. It's
almost what I need, except the Y-axis shows an accumulated count of
the values. What I need is to normalized the values so that they
represent a percentage. E.g., the total across the X-Axis is always
100% and the chart shows the percentage contribution of each value
being plotted.

100---------------------------------
80___ _________ _
60 \/ /\ \___/
40 /\______/ \ __
20/ \_____/
0----------------------------------

The SQL generated by the Wizard:

TRANSFORM Count(*) AS [Count]
SELECT (Format([Date],"\'yy\.q")) AS Expr1
FROM qryNeeds
GROUP BY (Year([Date])*4+DatePart("q",[Date])-1), (Format([Date],"\'yy
\.q"))
PIVOT qryNeeds.Need1;

I'm hoping that I can modify the SQL, rather than creating an
intermediate query.

Thanks,
Rich