PC Review

Thread Tools Rate Thread

pivot chart in a report

Harold Good
Posts: n/a
      21st Dec 2005
Hi, I'm new to Access. I have a report that displays Budget and Actual
expenses along with other info. I've created a Pivot Chart for these two
columns of data called "Budget" and "Actual" using the wizard, it is a
subform that I've pasted into the report. I'd like it to appear as a bar
chart with two vertical bars in the report.

But I don't know how to do this. By dragging the budget and expense fields
and dropping into the pivot chart, it seems to take away the control from
the Record Source as shown in propterties (which properly controls the other
info in the report). From the Pivot Chart itself (via the dropdown box) I
can choose which of the 200 projects to depict. But when it is in the
report, I'd like the Record Source to control this, so that as I flip
through the 200 reports, it will accurately depict the Budget vs Actual for
each project, as it does for the other info.

But I haven't figured out how to do this. I have all the info in the Record
souce query but it doesn't control that Pivot Chart. Or perhaps the Pivot
Chart isn't the right tool to use here?

Any experts with Pivot Chart experience - I'd sure appreciate your


Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicating Pivot Chart / Changing Pivot Chart data range BillG Microsoft Excel Misc 4 25th Feb 2010 03:15 PM
"A pivot table report cannot overlap another pivot table report" ExcelPowerUserWannaBe Microsoft Excel Worksheet Functions 0 22nd Jul 2008 05:36 PM
Best tool for adding a pivot chart like chart to a report? Kyle Jedrusiak Microsoft Access Reports 1 23rd Aug 2007 07:34 PM
How to create chart from Pivot table but not Pivot chart? =?Utf-8?B?RGFuaWVs?= Microsoft Excel Charting 1 31st Jul 2007 01:32 AM
A pivot table report cannot overlap another pivot table report. =?Utf-8?B?RGF2aWQ=?= Microsoft Excel Misc 1 23rd Jun 2005 11:42 PM




All times are GMT +1. The time now is 01:48 PM.