Results 1 to 3 of 3

Pivot Table Question

Threaded View

  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

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