+ Reply to Thread
Results 1 to 2 of 2

filter by x axis headings

  1. #1
    Forum Contributor
    Join Date
    08-22-2013
    Location
    Kent, England
    MS-Off Ver
    Excel 2010
    Posts
    157

    filter by x axis headings

    Hi all,

    I was wondering if it is possible to have the same selection in both the report filter and axis fields section on a pivot table.

    If not is there any way I can sort this so that I can have my headings along x axis as a filter so that I can easily change which headings are displayed?

    Thanks,

    Alex
    If this answer helped you then could you please click "Add Reputation"

  2. #2
    Forum Contributor
    Join Date
    08-22-2013
    Location
    Kent, England
    MS-Off Ver
    Excel 2010
    Posts
    157

    Re: filter by x axis headings

    Sorry, I no longer need the explanation...you can choose to have a filter displayed on the chart when you add your axis fields.

+ 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: 2
    Last Post: 03-27-2012, 05:55 PM
  2. putting column headings on the x-axis of each line chart
    By moonstar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2012, 11:17 PM
  3. Advanced Filter Macro (only returns column headings)
    By Mufasta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2011, 11:56 AM
  4. Filter but keep certain headings rows?
    By swithin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-25-2008, 01:19 PM
  5. Can I invert a table so row headings are now column headings etc
    By Sharon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-10-2005, 04:06 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