Posts by lambuhere1

I did have a look at andy's site. Its worth, But I dont have any idea if it meets my requirements.

Andy, are you listening

Ram P

Hi

Can anyone help me with a combinattion chart with Stacked column using one y-axis and a line chart over it using secondary y - axis.

In Excel we have only single column line chart combination graph.

Thanks

Ram P

I am not able to use the listed functions in my worksheet. I dont know where I am doing wrong.

Can anyone help.

Derk,

Thanks for your reply. But I am not able to FIT any trendline. Probably you can have a shot at it. Hence this post for help.

Hi

I am trying to fit a trend line for a chart in the attached workbook, OTHER THAN MOVING AVERAGES.

Can anyone help me in fitting a trendline?

Thanks

Ram P

How about using DATEDIF worksheet function for your year, month, date extraction?

Hi

I am trying to use the following code to Extract trendline coefficients into the worksheet, But I am unsuccessful. Can anyone please tell me what I am doing wrong?

http://groups.google.com/group…news.microsoft.com&rnum=1

Thanks a lot for your help.

Ram P

Thanks Andy. I shall look into the link provided.

Ram P

Andy, Herein is the file for your reference. I could not reply early as my IP was down.

Thanks for your help.

Ram P

Hi Andy

Great to hear from you. I had a plot of 3D Surface plot with the necessary data. It shows in 3D format according to the data supplied. Now I need to fit a equation for this surface generated. I know its a tough job. But is there any way we can fit a surface equation for this plot.

I hope I am clear on this. If not, do let me know

Thanks

Hi

I know how to plot a surface chart. Is there anyway I can fit a equation to the data? Any ideas are highly appreciated.

Thanks

Neale, I did try your option. It doesnt work. I get a comma in the cell instead of the number.

Thanks

Ram P

Hi,

I would like to know how to format 100000.00 as 1,00,000.00
or 1000000 as 10,00,000.00 . I have tried changing the Regional Settings (Start --> Control Panel --> Regional Settings ; Change the Number settings).

It doesnt work. Can anyone shed any more thoughts?

Thanks

Ram P

You need to copy each chart to a temporary workbook and then add this to each slide of your presentation.

Do send me a U2U if you require any assistance in this.

Thanks

I am using that you shall be typing data into textboxes.

Use the following code to extract the data from textbox on form to worksheet

Worksheets("Sheet1").cells(1,1).value = userform1.textbox1.value

Hope this helps.

Ram P

Dave

Thanks for your help.

I think Now I need to refine the code to inculde the data in subsequent columns if data rows exceed 65536.

THanks for your help.

I hope you are doing fine in Australia !!

Dave

Thanks a lot for your kind help. I do like this. I did try to understand the code. But it works only for 9 characters. Is there any way we can increase the number of characters to say 10 or 15 max?

Thanks

Hi

I would like to have your kind help in getting various names using different characters. Lets say for e.g., a husbands name is ABC and wifes name is DEF. I would like to use a combination of characters to get different possible names using both ABC and DEF... like ABCDEF, ABCDFE etc. I know it involves a bit of coding, But I am unsucessful till date.

Could anyone be kind enough to help me in this?

Thanks

Ram P

You can use VBA something like this.

i = ActiveSheet.Hyperlinks.Count
link_1 = ActiveSheet.Hyperlinks(1).Name

use the LEN function and a array to store all your link names and then reassign then with a new string.

This should guide you futher in replacing the links.

Hi Andy

I do hope that you can answer this.

Is there any limitation on the number of bubbles that can be plotted on "Bubble" Chart. I have a collegue of mine who wants to plot X vs Y for 200 customers. He wants to control the size of these bubbles for each Y contribution. Can you kindly guide me in this?

I think 200 is a large number for Bubble representation. Is there any way we can control the size for these 200 Y's?

Thanks