Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Aug 2014
    Posts
    31
    Thanks
    11
    Thanked 0 Times in 0 Posts

    Question Excel 2010 Pivot Slicer

    Hi all,

    Hopefully, just a quick one.

    I have a dashboard on Sheet1, and one of the charts runs off 2 pivots on Sheet2. I have linked both tables to the slicer, and this is working fine.

    Is there a way I can move the slicer next to the chart on Sheet1, thus enabling me to hide the tab containing the pivot?

  2. #2
    Lounger
    Join Date
    Aug 2014
    Posts
    31
    Thanks
    11
    Thanked 0 Times in 0 Posts
    No problem, I figured it out.

    I was trying to copy it, and paste it on the graph area, which forced it to paste as an image.

    If I pasted it to a cell however, it pasted as an active slicer, and I was able to then drag it closer to the chart.

Posting Permissions

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