Problems w/ creating a Report Chart

[Tom]

I need some help with "charting" in Access. I have used the Excel charts
(very straightforward) before, but
charting in Access seems to be a bit differnt.

For testing purposes, I have created a sample database.

The db contains only 1 table (Table1) with 2 fields (Region, Sales).
Organization = Text; Sales = Number.

I added only 3 records:
Region1; 40
Region2; 25
Region3; 35


I now use the Report Wizard to create sales report. Based on the sample
data, the report is very simple.


Okay, I now want to add a "pie chart" to the report. I already added the
"chart icon" to my toolbar. And here
are the steps I'm performing.



Steps in Chart Wizard:
1. Open report (no grouping is applied in report)
2. Drag the chart into the footer
3. Select "Table1" as the source
4. Select both fields "Region" & "Sales"
5. Select "Pie"
6. Layout: Accept default layout in preview (Region & SumOfSales)
7. Accept report field "Region" & chart field "Region"
8. Accept default report name "Table1"
9. Finish


Okay, here now is the problem... when I preview the report, the pie chart is
NOT broken into the
3 regions and their respective fields.

The entire chart color is "blue" and one of the labels indicates "Region3".
Why is that? Why wouldn't I
see the chart broken into its 3 segments?

Any suggestions?


Tom

 

[Duane Hookom]

What is the row source of the chart control. This property determines what
is displayed in the chart.

 

[Tom]

Duane:

The row source (created by the wizard) equals

SELECT [REGION],Sum([SALES]) AS [SumOfSALES] FROM [Table1] GROUP BY
[REGION];

I still only see "one big block" of the data. It's not broken into the 3
regions in the print preview... even though I can see them broken out in
report design view.

Any ideas what's going on here?

Tom

 

[Duane Hookom]

Are you using data from the table in your report or just the graph? If you
aren't using data in the report then remove the report's record source. If
you need the report's record source then make sure you don't have the Link
Master Child properties set.

--
Duane Hookom
MS Access MVP

Duane:

The row source (created by the wizard) equals

SELECT [REGION],Sum([SALES]) AS [SumOfSALES] FROM [Table1] GROUP BY
[REGION];

I still only see "one big block" of the data. It's not broken into the 3
regions in the print preview... even though I can see them broken out in
report design view.

Any ideas what's going on here?

Tom

What is the row source of the chart control. This property determines what
is displayed in the chart.

--
Duane Hookom
MS Access MVP


chart

 

[Tom]

Duane:

Yes, that was it... it works perfectly now.

Out of curiosity, why did the wizard create the link to "Master" & "Child"
properties? Is there a time when I should use those?

Thanks,
Tom

Are you using data from the table in your report or just the graph? If you
aren't using data in the report then remove the report's record source. If
you need the report's record source then make sure you don't have the Link
Master Child properties set.

--
Duane Hookom
MS Access MVP

Duane:

The row source (created by the wizard) equals

SELECT [REGION],Sum([SALES]) AS [SumOfSALES] FROM [Table1] GROUP BY
[REGION];

I still only see "one big block" of the data. It's not broken into the 3
regions in the print preview... even though I can see them broken out in
report design view.

Any ideas what's going on here?

Tom

What is the row source of the chart control. This property determines what
is displayed in the chart.

--
Duane Hookom
MS Access MVP


I need some help with "charting" in Access. I have used the Excel charts
(very straightforward) before, but
charting in Access seems to be a bit differnt.

For testing purposes, I have created a sample database.

The db contains only 1 table (Table1) with 2 fields (Region, Sales).
Organization = Text; Sales = Number.

I added only 3 records:
Region1; 40
Region2; 25
Region3; 35


I now use the Report Wizard to create sales report. Based on the sample
data, the report is very simple.


Okay, I now want to add a "pie chart" to the report. I already

added
the

"chart icon" to my toolbar. And here
are the steps I'm performing.



Steps in Chart Wizard:
1. Open report (no grouping is applied in report)
2. Drag the chart into the footer
3. Select "Table1" as the source
4. Select both fields "Region" & "Sales"
5. Select "Pie"
6. Layout: Accept default layout in preview (Region & SumOfSales)
7. Accept report field "Region" & chart field "Region"
8. Accept default report name "Table1"
9. Finish


Okay, here now is the problem... when I preview the report, the pie chart
is
NOT broken into the
3 regions and their respective fields.

The entire chart color is "blue" and one of the labels indicates
"Region3".
Why is that? Why wouldn't I
see the chart broken into its 3 segments?

Any suggestions?


Tom

 

[Duane Hookom]

This is quite often a very good feature. It work much like subreports and
subforms that display records related to a value in the report section. This
is demonstrated in the "At Your Survey" sample at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

--
Duane Hookom
MS Access MVP

Duane:

Yes, that was it... it works perfectly now.

Out of curiosity, why did the wizard create the link to "Master" & "Child"
properties? Is there a time when I should use those?

Thanks,
Tom

Are you using data from the table in your report or just the graph? If you
aren't using data in the report then remove the report's record source. If
you need the report's record source then make sure you don't have the Link
Master Child properties set.

--
Duane Hookom
MS Access MVP

Duane:

The row source (created by the wizard) equals

SELECT [REGION],Sum([SALES]) AS [SumOfSALES] FROM [Table1] GROUP BY
[REGION];

I still only see "one big block" of the data. It's not broken into

the

3 determines
what