+ Reply to Thread
Results 1 to 1 of 1

How to display pivot chart (one a time) frm multiple sheets on one SINGLE sheet

  1. #1
    Registered User
    Join Date
    10-10-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to display pivot chart (one a time) frm multiple sheets on one SINGLE sheet

    Hello,

    I have uploaded my workbook contains of multiple pivot charts. I have 2 questions to ask here.

    1) As there are many pivot charts (one on one sheet), i would like to see only one single sheet that with button or drop down list added so I can choose which chart I like to see and it will display out.When I choose chart A, it will display on that default sheet. Same as when I choose chart B, it will display on that default sheet.

    2) I have displayed out year (YY), month (MM) on top of my pivot chart, is it possible to remove the "Period" field button at the bottom as it seem a duplicate stuff over there.

    Are both of my questions able to be done? Thanks a million in advance
    Attached Files Attached Files

+ 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