Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2014
    Posts
    1

    Unanswered: pivot chart in a report

    Hi

    I am trying to link my pivot chart form as a inserted graph into a report. I want the pivot table to pick up the grouping options from the report above so that it is only showing revenue for the above filtered requirements (which can be changed depending on what information is needed). however I cannot get them to link.

    Is this the best way to tackle this or will another approach give me a revenue graph sorted as per the groups in the report.

    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    design your (Pivot) query
    design your graph based on that query
    insert the graph into the report


    each time you run the report the graph will pickup the current values from the query
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •