$$Excel-Macros$$ Re: URGENT Help! How to display "Period" the data has been selected through the timeline.

2014-07-01 Thread Prayank Vidyarthi
croll down to view other sections of the dashboard which are connected with this timeline, is it possible to get the period selected in a predefined cell which could be the header of that section? Regards Prayank On Friday, June 27, 2014 2:59:45 PM UTC+5:30, Prayank Vidyarthi wrote: > > Hi

$$Excel-Macros$$ URGENT Help! How to display "Period" the data has been selected through the timeline.

2014-06-27 Thread Prayank Vidyarthi
Hi Excel Gurus, I need your help as I am really stuck over here. I have data starting from Nov 2012 till March 2014. I have created various charts for my dashboard and have also inserted a timeline slicer to my pivots. The orientation of this dashboard is portrait and the timeline is given on t

$$Excel-Macros$$ Help with 5 line charts from one pivot table

2014-06-23 Thread Prayank Vidyarthi
Hi, If I have a pivot table (as shown below) in which destinations sold has been sorted as Top 5 and Month has been sorted as Top 3. I wanted to create 5 different line charts showing each destination separately. For e.g. One line chart showing Malaysia, 2nd line chart showing Switzerland, 3rd

$$Excel-Macros$$ Re: Help with a pop up window with relevant information upon clicking a value in cell

2014-05-15 Thread Prayank Vidyarthi
Hi Vaibhav, Thanks for the prompt response. It works. As I am an alien to VBA, I would appreciate if you could also help in fixing the formatting issue. Best regards Prayank On Thursday, May 15, 2014 2:16:21 PM UTC+5:30, Prayank Vidyarthi wrote: > > Hi, > > I have a dashboard wi

$$Excel-Macros$$ Re: Introduce Yourself !!

2014-05-15 Thread Prayank Vidyarthi
Hi Excel Gurus! I am Prayank Vidyarthi from Gurgaon. I work for the Modigroup of companies in the travel space as a Sr. Manager Business Planning. My role includes a lots of analysis and number crunching, hence I landed here. Apart from work, I love to: Play Cricket and Table tennis, Draw and

$$Excel-Macros$$ Help with a pop up window with relevant information upon clicking a value in cell

2014-05-15 Thread Prayank Vidyarthi
Hi, I have a dashboard with 3 columns as depicted below, where year means the period referred to, Newbees are the new agencies and Existing are the already existing agencies. Year Newbee Existing 2010-11 2.12 163.43 2011-12 7.92 206.04 2012-13 11.83 236.19 2013-14 16.95 237.90 What I want to