$$Excel-Macros$$ bubbel chart help required.

2013-03-20 Thread Midhun Thampan
hi all; i want to create the bubble chart of the following data. not able to create as all the data is not reflecting. also the x axis should display high ir low instead of the number. kindly help me out. -- Midhun Thampan. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be

Re: $$Excel-Macros$$ Re: Repair File

2013-03-20 Thread Prakash
Hi Kantilal, What are the error messages??? Can you share the error message? Without the error message, I am unable to answer. On Tuesday, March 19, 2013 7:10:00 PM UTC+5:30, kantila...@gmail.com wrote: > > Thanks Prakash, > > I tried following steps before sharing the file. But could not rec

Re: $$Excel-Macros$$ data sheet help needed

2013-03-20 Thread >>Excel Beginner<
Hi Girish, Try this =LOOKUP(2,SEARCH(G$4,$A$4:$A$15185)*SEARCH($F5,$B$4:$B$15185),$C$4:$C$15185) On Wed, Mar 20, 2013 at 10:48 AM, M S GIRISH wrote: > > Thank you anil > > It is working on the first column when it drag to another column it is > shows erroor and Instead of "N/A" it sh

Re: $$Excel-Macros$$ Help with Deciphering an Excel Formula

2013-03-20 Thread Sam Mathai Chacko
Here's an explanation to a similar but not exactly same formula. I'm sure you can decipher your equation once you go through the link below. http://www.excelfox.com/forum/f13/extract-number-alphanumeric-text-186/ Regards, Sam Mathai Chacko On Wed, Mar 20, 2013 at 8:15 PM, Chris wrote: > Hi Ev

$$Excel-Macros$$ Help with Deciphering an Excel Formula

2013-03-20 Thread Chris
Hi Everybody, I thought I had somewhat advanced Excel skills but then the following made me feel like I'm back in the beginners' group: Usually people ask here how to achieve something in Excel or VBA. I actually have the answer but I would like to understand it. This morning, I needed a quick

$$Excel-Macros$$ Re: Macro to be added to new sheets when created from a template

2013-03-20 Thread Shekhar
Hi Hilary, Replace ThisWorkbook.Sheets("Template") with Activesheet in procedure called selectResults. I believe you are good to go... :) One more thing you may need to consider: If you are adding a sheet which is already exist in the workbook, the code produces an error. To avoid this you can

Re: $$Excel-Macros$$ Financial year Graph

2013-03-20 Thread Chaya
Dear All Experts, Thank you so much for the help. On Wed, Mar 20, 2013 at 5:45 PM, prafull jadhav wrote: > HI Find the same. > > > On Wed, Mar 20, 2013 at 5:09 PM, Vinay Saraf wrote: > >> You should sort your data.. >> >> *From *Jan to Dec >> *TO April to March* >> >> On Wed, Mar 20, 2013 at 4:

Re: $$Excel-Macros$$ Financial year Graph

2013-03-20 Thread prafull jadhav
HI Find the same. On Wed, Mar 20, 2013 at 5:09 PM, Vinay Saraf wrote: > You should sort your data.. > > *From *Jan to Dec > *TO April to March* > > On Wed, Mar 20, 2013 at 4:59 PM, Chaya wrote: > >> Dear Experts, >> >> I want to plot a graph with the financial year >> start

Re: $$Excel-Macros$$ Financial year Graph

2013-03-20 Thread Vinay Saraf
You should sort your data.. *From *Jan to Dec *TO April to March* On Wed, Mar 20, 2013 at 4:59 PM, Chaya wrote: > Dear Experts, > > I want to plot a graph with the financial year > starting from April to March. Actually my datas are starting with the Jan > month to Dec but

$$Excel-Macros$$ Financial year Graph

2013-03-20 Thread Chaya
Dear Experts, I want to plot a graph with the financial year starting from April to March. Actually my datas are starting with the Jan month to Dec but I want the graph which shows for me from financial year-April to march. Please advice me is there any option to select ith fi