+ Reply to Thread
Results 1 to 2 of 2

Pivot Charts

  1. #1
    Registered User
    Join Date
    06-04-2008
    Posts
    2

    Pivot Charts

    Hi,

    I've got a huge amount of data stored in a pivot table that I'm trying to graph.

    There are 26 different variables, and essentially a value by week for each of these.

    I'm new to Pivot charts so forgive me if this seems like an easy question - but my problem is that I can't seem to choose which variables to chart? Ideally I want 5 or 6 different graphs with similar variables grouped together on each. Is this possible?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436
    You would need a separate pivot table for each of the charts.

    The chart should have field selectors available for you to filter the information displayed.
    If you return to the pivot table and restrict the information in the table the chart will reflect those changes.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1