I am a Chart Idiot...looking for help

[Guest]

I am missing some pretty simple concepts I guess.

I have created a 500 page report...one page per record. The data on each
page is organized into 4 categories...call them A B C and D. And a numeric
total is reported for each.

The % of the total value within each category is also reported.

I simply want each page to display a pie chart of those 4 % of total values
for each category. Which are already disctinct columns available in this
report, with labels A%, B%, C% and D%...but I cannot make any chart display
those values.

Any help would be apreciated.

txs,
Tom

 

[Duane Hookom]

I think part of your issue may be that you have four columns rather than a
normalized four rows. The At Your Survey sample application has a pie chart
based on a groupoing within a report. This might give you some idea of how
this can be done.

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[Guest]

I will take a look. Tks for the response.

On same topic...this data is already "normalized" I think. What I think you
are suggesting that if my data was transposed..that I would be able to do
what I want? Because the "raw" data (obtained from a query) has ~500 rows,
with 15-20 columns of items like Name, ID and these fields I am talking
about. And looking ahead, there is no real way to transpose it...

Txs,
Tom

 

[Guest]

I took a look...if you can explain the Row Source line, it would help...

SELECT ttblSurveyResponses.Rspns, ttblSurveyResponses.[Number of Responses]
FROM ttblSurveyResponses;

Alternatvely...if you tried to report the responses from an individual
respondent, what would be the Row Source (or other Properties elements) if
answers to 4 questions had to numerically add to 100, and you wanted to pie
chart them?

Txs,
Tom

 

[Duane Hookom]

I just created a crosstab query that has Country as a Row Heading, Quarter
of SalesDate as the Column Heading, and sum of Freight as the value. So my
query looked like:

Country Q1 Q2 Q3 Q4
Argentina 546 28 0 23
Austria 1812 2418 1070 2089
....
I based my report on this query and added a pie chart to the detail section
of the report. The link Master/Child properties of the chart control are
[Country].

The Row Source of the report is
SELECT Country, Q1, Q2, Q3, Q4
FROM qxtbSalesByQtrAndCountry;

The pie chars all displayed as neede by setting the "Series in Rows".


--
Duane Hookom
MS Access MVP

I took a look...if you can explain the Row Source line, it would help...

SELECT ttblSurveyResponses.Rspns, ttblSurveyResponses.[Number of
Responses]
FROM ttblSurveyResponses;

Alternatvely...if you tried to report the responses from an individual
respondent, what would be the Row Source (or other Properties elements) if
answers to 4 questions had to numerically add to 100, and you wanted to
pie
chart them?

Txs,
Tom

I will take a look. Tks for the response.

On same topic...this data is already "normalized" I think. What I think
you
are suggesting that if my data was transposed..that I would be able to do
what I want? Because the "raw" data (obtained from a query) has ~500
rows,
with 15-20 columns of items like Name, ID and these fields I am talking
about. And looking ahead, there is no real way to transpose it...

Txs,
Tom

 

[Guest]

Now that sounds like something I might be able to follow and implement in my
instance. Tks again..I will take a look and see if I can figure it all out.

I just created a crosstab query that has Country as a Row Heading, Quarter
of SalesDate as the Column Heading, and sum of Freight as the value. So my
query looked like:

Country Q1 Q2 Q3 Q4
Argentina 546 28 0 23
Austria 1812 2418 1070 2089
....
I based my report on this query and added a pie chart to the detail section
of the report. The link Master/Child properties of the chart control are
[Country].

The Row Source of the report is
SELECT Country, Q1, Q2, Q3, Q4
FROM qxtbSalesByQtrAndCountry;

The pie chars all displayed as neede by setting the "Series in Rows".


--
Duane Hookom
MS Access MVP

I took a look...if you can explain the Row Source line, it would help...

SELECT ttblSurveyResponses.Rspns, ttblSurveyResponses.[Number of
Responses]
FROM ttblSurveyResponses;

Alternatvely...if you tried to report the responses from an individual
respondent, what would be the Row Source (or other Properties elements) if
answers to 4 questions had to numerically add to 100, and you wanted to
pie
chart them?

Txs,
Tom

I will take a look. Tks for the response.

On same topic...this data is already "normalized" I think. What I think
you
are suggesting that if my data was transposed..that I would be able to do
what I want? Because the "raw" data (obtained from a query) has ~500
rows,
with 15-20 columns of items like Name, ID and these fields I am talking
about. And looking ahead, there is no real way to transpose it...

Txs,
Tom

:

I think part of your issue may be that you have four columns rather
than a
normalized four rows. The At Your Survey sample application has a pie
chart
based on a groupoing within a report. This might give you some idea of
how
this can be done.

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
--
Duane Hookom
MS Access MVP

I am missing some pretty simple concepts I guess.

I have created a 500 page report...one page per record. The data on
each
page is organized into 4 categories...call them A B C and D. And a
numeric
total is reported for each.

The % of the total value within each category is also reported.

I simply want each page to display a pie chart of those 4 % of total
values
for each category. Which are already disctinct columns available in
this
report, with labels A%, B%, C% and D%...but I cannot make any chart
display
those values.

Any help would be apreciated.

txs,
Tom