+ Reply to Thread
Results 1 to 3 of 3

Pivot Table Question

  1. #1
    Registered User
    Join Date
    10-12-2009
    Location
    Scotland
    MS-Off Ver
    Excel 2007
    Posts
    95

    Pivot Table Question

    I have a pivot table and chart as attached. It has:
    Rows = Sections
    Colum’s = decks
    Values = signal types
    Currently it is displaying values for all systems. I want to be able to filter on specific systems which I can do by dragging the systems field into the filter. However my rows and columns realign to the data specific for that system as you would probably expect, except if possible id like to keep the full columns and rows data in my chart as its effectively the axis for my 3d chart and provides a good visual overview of the density of signals with respect to the overall landscape.
    Is there anything I can do to make this so?
    Attached Images Attached Images
    Check out my photography site, Lens Art http://www.lensart.me.uk

  2. #2
    Registered User
    Join Date
    10-12-2009
    Location
    Scotland
    MS-Off Ver
    Excel 2007
    Posts
    95

    Re: pivot table question

    Ive created a non sensitive excel book to hopefully show what im looking for.

    You will see the top pivot table shows all systems, this is great and works fine.

    The bottoms pivot table is filtered to show only one system. But if possible id like the bottom pivot to still show the same chart ranges, i.e 1-10 and A-I as these actually represent geographical coordinates. It would be nice to see where that systems data sits with respect to the full geographical landscape in isolation from the other systems. But currently all it does is shows from 1-4 and A-B as it only has data I those coordinates
    Hope that makes sense
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-12-2009
    Location
    Scotland
    MS-Off Ver
    Excel 2007
    Posts
    95

    Re: Pivot Table Question

    ......anyone?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 07-01-2011, 01:36 AM
  2. Pivot Table Question
    By iaaw100aes in forum Excel General
    Replies: 4
    Last Post: 12-01-2008, 07:02 PM
  3. Pivot Table question
    By dopeyfrogg in forum Excel General
    Replies: 1
    Last Post: 11-21-2008, 08:13 AM
  4. [SOLVED] Pivot Table Question
    By Debby Bunce in forum Excel General
    Replies: 0
    Last Post: 08-22-2006, 04:05 AM
  5. [SOLVED] Pivot Table Question : If statment in Pivot Table??
    By seve in forum Excel General
    Replies: 2
    Last Post: 11-21-2005, 09:10 PM
  6. [SOLVED] Pivot Table Question
    By Ray S. in forum Excel General
    Replies: 1
    Last Post: 11-15-2005, 03:10 PM
  7. [SOLVED] Pivot Table Question.
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2005, 06:50 PM
  8. [SOLVED] pivot table question
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 05-26-2005, 05:15 PM

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