Bingooo... Narayank the great....
only dynamic chart heading which i was used is not showing only region name showing...
I think you change the dynamic chart heading...
Also the last column of data from which chart made showing same data in all row...
It will be great if you expalin what...
Thanks both and sorry for late reply as i was travelling.
@Suresh Kumar... file not working in my pc.
@narayank991.... can you please upload in 2shared.com speedy.sh is block in my country.
and request you both can you please explain me. I just dont want to complete but want to understand...
Hello Ninja's
Can any1 please check the file what is the problem.
I am unable to catch where i was making mistake.
I watch chandoo's video but unable to do it.
http://www.2shared.com/file/mu8AMipj/hyperlinkchart.html
Thanks
Regards,
Pavi
Hi Faseeh,
Tell me if you will submit this report then what colour scheme will you use.
just asking because you are one on the Excel Ninja.
Regards,
Pavi.
Dear Faseeh & Hui,
I uploaded the file please suggest me how can i improve the formatting.
http://www.2shared.com/file/Y6giNoBP/2010_to_2012_West.html
Thank you Ninjas...
Regards,
Pavi
Hi all,
Please suggest me how to represent a report with figures as my GM dont like graph and other stuff...
Please help me to present report in good way which look good even with figures also.
Regards,
Pavi
Dear nazmul_muneer,
Yes i seen ur post but this is different problem.
I m not able to install ASAP due to Administator restriction.
i want to compile 13 file not worksheet.
all 13 file contain 1 sheet only namely(Vehicle Expenses_2000,Vehicle Expenses_2001 till Vehicle Expenses_2012)...
Hi Ninja & All,
Can any1 give me the code or trick to compile 13 excel file in one. (All excel file have same header). Please help me...
Thanks a lot.
Regards,
Pavi
Hi All,
below formula not working Selcell (Name Range(B1))is link to radio button.
=IF(SelCell="1",D5,IF(SelCell="2",P5,IF(SelCell="3",AB5,IF(SelCell="4",AN5,""))))
Please help...
Thanks Kaushik...
I m using 2010 but i want to use Radio button.
On my main sheet i have 4 radio button which i want to link to pivot.
if user click on one of radio button then data should update in below table...
Actual i have 4 product so i want one table to show selected product usin...