to Duane Hookom - how to use Pivot Charts for individual records instead of summing all records

[Harold Good]

Hi David,

I have a basic question about Pivot Charts.

I've designed one as a bar chart with two bars as a form to insert into a
Report. Each of the 200 or so records include two fields "Budget" and
"Actual". I'd like this chart to appear as a small graph on each report
(each report is one page for each of the 200 projects), but with the Budget
and Actual Pivot Chart showing the info for that specific project (record).

But everything I see in my pivot chart seems to want to sum ALL the Budgets
and ALL the Actuals. I don't want sums, I want the data for the Pivot chart
linked to the Budget field for that record.

Is there a way to do this? I've scoured the net and my books but can find no
solution.

So I don't want sums, just a link to records that hopefully will be updated
as data changes.

Thanks for any help you can offer.

Harold

 

[Duane Hookom]

I don't use pivot charts in Access. Is there a reason why you are using a
pivot chart in your report and not a standard chart?