Help with MS Access Chart in Report

[Leslie Coover]

I am working on a simple pie chart that has several
different labels. I want to arrange the labels evenly
around the pie chart so they are all visible and there
are no overlaps.

In Design View, when I double-click on the chart the
Data Labels are not the same as in Print Preview, so
I can't move the Data Labels around to orient them
correctly in relation to the pie chart.

In Design View only 3 sections of the pie chart appear,
the Data Labels are: East 21%, North 47%,
and West 32%. In Print Preview all the sections appear with
appropriate Data Labels e.g., First Class 1%,
Advance 3%, Nonrefundable 11%, Discounted 21%,
Capacity 21%, Negotiated 42% etc.

How can I use Design View to arrange the Data Labels
on my pie chart?

MS Access 2000, 2003
Thanks, Les

 

[Duane Hookom]

Search this news group for a subject of "Charts in reports" on June 20th
from Robert Raley.

 

[Leslie Coover]

Thanks Duane

I found: "Create your chart first on a form. After you get it properly set
up, copy and paste it into your report. It will then show the correct data
in
design view."

I could only get this method to work if I used the Form Chart Wizard. Still
had a problem with Insert Chart, even in Form View. I retried the Form
Chart Wizard several times and it worked every time. I did all editing in
Form View then pasted the chart into a Report. The chart seems to work
fine. The chart is based on a query. After the report with the chart was
finished I changed the original table data and the chart displayed all
changes correctly.

Les

 

[SA]

Leslie:

If you want the data you are displaying to show up in the graph datasheet
and graph itself when you flip to design view, add this code to the report's
on print event of the section containing the graph object:

Dim objGraph as Object
Set objGraph = Me!NameOfTheGraphObject.object
objGraph.Application..Update
Set objGraph = Nothing

It will then populate the datasheet with your data and the graph will show
your data when in design mode.