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:
    5
    Views:
    643
    Guest
    Jun 20, 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:
    180
    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:
    291
    Guest
    Jun 24, 2006
  4. Guest

    Creating a Report from a Pivot Chart

    Guest, Oct 17, 2006, in forum: Microsoft Access Reports
    Replies:
    0
    Views:
    191
    Guest
    Oct 17, 2006
  5. 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:
    468
    Guest
    Aug 23, 2007
  6. Joek

    Access Pivot chart in Report

    Joek, Oct 17, 2008, in forum: Microsoft Access Reports
    Replies:
    2
    Views:
    12,322
    Axess08
    Oct 17, 2008
  7. 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,395
    Keith Wilby
    Sep 8, 2009
  8. Rob
    Replies:
    0
    Views:
    494
Loading...