Recent content by sangramkesharijena

Hi Somendra, Thanks for your great help. You saved my lot of time. Regards Sangram

Hi, Thanks for your reply. My requirement is for first chart suppose value is >5 in column F then bar color should be change to Red automatically if less then 5 then green and suppose in column L & R value is >=95% then the bar chart color should automatically change to green if value is <=95...

Hi, I am preparing a weekly report that measures the employee performance. The bar color should be Red -If value is <=94.99% score, Green If >=95%). Is there any way, using VBA or a macro, to change the color of a bar (data point) automatically based on the value. Can it run through all of...

Dear Ravikiran, Thank you so much for your reply. Please find the attached xlsm file.While running the macro in Pivot Table ROW LABEL-"TASK CODE" is not giving the out put. I have mentioned all the detail in the attach file.Please help me to resolve the problem. Regards sangram

Hi, My data sheet consits of Current week (CW) 44,45,46 etc and Task code A,B,C,D etc. Want to know for Current week-44 how may task A,B,C completed then CW-45 how many task B,C,D completed then so on.... In pivot Table Report Filter filed column draging "Current week", Row Lable "Task code"...

Can any body help me to get the Sumproduct concept

Hi Marc L, I need the VBA macro solutions because facing the above issue. Your Title name should always unique so you may get attention an it worked also. I do not think the title should change. Thank you.

Hi, I am new to Excel VBA programming. Recorded the macro for pivot table but it is not working properly. My data sheet consits of Current week (CW) 44,45,46 etc and Task code A,B,C,D etc. Want to know for Current week-44 how may task A,B,C completed then CW-45 how many task B,C,D completed...

Hi, Kindly assist me to get the result. Below are the data of the varioius invoices that has been pending report as shown across below. Eg--&#62; All those invoice amounts where the invoice date is within 30 days from todays date needs to be summarized and shown under "0-30 Days", Eg--&#62...