Search results

This sounds interesting, Let me try that. Thanks.

I have already created but I was looking for some perfections. Anyway, thanks.

Do you have any such template?

Thanks. However, the link does not say how to create in excel. I want to create the same in excel.

I am looking for the first one the half circle...How to prepare that in excel?

Like the way they show election results...the dotted pie chart kiind of....

Is there a way to create parliament chart in excel?

Hello, Need some guidance in preparing Fibonacci chart in excel. Regards, Jay POST MOVED BY MOD

Hello, I need some suggestions on best chart/graph to put to show month end closed inventory and revenue days/DSO to gether with a comparison to prior year. Regards, Jay

This helped. Thanks Narayan. Regards Jay

Hello, Kindly guide me on how can I get lets say top 20% of the total clients on the basis of revenue in a pivot table. Regards Jay

Thanks Luke.....It works... Regards Jay

Hello, How to have a dynamic data range for a bar chart. When I select an item from a drop down the data range should move to a corresponding row for the row header selected. Kindly help. Regards Jay

Hello, How I can add a customised tool bar in excel where all the clicks are vba enabled? Regards Jay

Thanks all. I think I got it. Regards Jay

Hello, Please guide me on offset formula. Regards Jay

Thanks. How can I do that? Please guide. Regards Jay

Thanks Hui, but putting the color is a judgemental call( manual effort ) and the number may not change everytime, but color changes. Regards Jay

Thanks for the quick reply but I need the function to calculate automatically when cell color changes in the range. Regards Jay

Hello, I have this below code. but everytime there is a change in color in the range, I have to press F2 then press enter to recalculate teh formula. Can you please guide me in fixing that issue so that whenever there is a change in color the formula recalculates automatically and I do not have...

Thanks Narayan for the help.

Thanks Narayan. It is working. But everytime I have to open the external file to refresh the data. Is there any other way, where the data will be refreshed automatically withouth opening the external file? Regards Jay

Thanks Narayan. Yes, that is exactly what I want. I used the formula as you said using Indirect, but its not working.

Hi Narayan, Yes, I am using the sheet name selected in the drop-down in a formula.I copy pasted the formula above at the beginning of this converstaion. again copying the same below. ='C:UsersjsarangiDocumentsFNNFY 2000Q2Working Files1 23 2000[FY13 Q3 Fnn Quarty Comson (01 23...

Actually, I am linking one file to another with a drop down of sheet name. That is, as I choose a name from the drop down the link should move to another sheet. the sheet name and the drop down list are the same. The cell may contain both numeric and text. Let me know if you need any further...