Help with Pie Chart

[Georgi]

Good evening Gentlemen,



How can I create a pie chart with two different fields, or with field and a fixed number i.e. ([training rate] is the training hours divided by session) and fixed number which is the target rate 1.75 or so.

Please see attached excel sample and the access that I am trying to create a pie chart.

Thank you for all,

[June7]

Spreadsheet shows Sessions divided by Hours - not the reverse as you stated - which do you want?

Have to get the data into one field. A UNION query will do that.

SELECT "Rate" AS Category, Rate FROM (SELECT Sum(Training.[Training Hours]) AS SumHrs, Sum(Training.[Training Sessions]) AS SumSess, Round([SumSess]/[SumHrs],2) AS Rate
FROM Training) As Q1
UNION SELECT "Target", 1.75 FROM Training;

Chart RowSource:
SELECT Category, Rate FROM Query1;

[Georgi]

Spreadsheet shows Sessions divided by Hours - not the reverse as you stated - which do you want?

Have to get the data into one field. A UNION query will do that.

SELECT "Rate" AS Category, Rate FROM (SELECT Sum(Training.[Training Hours]) AS SumHrs, Sum(Training.[Training Sessions]) AS SumSess, Round([SumSess]/[SumHrs],2) AS Rate
FROM Training) As Q1
UNION SELECT "Target", 1.75 FROM Training;

Chart RowSource:
SELECT Category, Rate FROM Query1;

Good evening Mr. brilliant, I just tried it, you are just amazing really, thank you very much and I do apologise for bothering every time with my questions. It works, 100% what I am looking for, thanks again.

[June7]

No apology needed. I know graphs are challenging. Solving issue gives me practice.