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
Bookmarks