pivot chart in a report

Discussion in 'Microsoft Access Reports' started by Harold Good, Dec 21, 2005.

  1. Harold Good

    Harold Good Guest

    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
    assistance.

    Harold
     
    Harold Good, Dec 21, 2005
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest
    Replies:
    0
    Views:
    299
    Guest
    Jun 30, 2005
  2. Michael

    how can I spread out a pivot chart in a report?

    Michael, Jan 11, 2006, in forum: Microsoft Access Reports
    Replies:
    0
    Views:
    121
    Michael
    Jan 11, 2006
  3. Guest

    Transform a Pivot chart into a report

    Guest, Jun 24, 2006, in forum: Microsoft Access Reports
    Replies:
    0
    Views:
    242
    Guest
    Jun 24, 2006
  4. Kyle Jedrusiak

    Best tool for adding a pivot chart like chart to a report?

    Kyle Jedrusiak, Jul 10, 2007, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    319
    Guest
    Aug 23, 2007
  5. Mal Praktis

    Report with pivot tables and pivot charts in sub reports

    Mal Praktis, Aug 5, 2009, in forum: Microsoft Access Reports
    Replies:
    6
    Views:
    1,016
    Keith Wilby
    Sep 8, 2009
Loading...

Share This Page