Posts by lambuhere1

Andy

I am confused with the chart picking up the order of data arrangement from your Drop Down Boxes on the chart. And your restriction of chart for only 5 data series. How are you able to restrict the series and how is the selected data getting picked up for the chart?

Thanks Andy for your explanation. You are really a Wizard on Charts!! :cheers:

Thanks Andy for your Add-in. It does work for objects on the worksheets, But not for independent Userforms.

I shall beusing it for my variousother applications.

Thnaks

Ram P

I presume that I can use the PrintForm feature instead of GIF images..

Thanks Everyone for your kind suggestions.

If I use the ClipBoard option and then crop the image, I may have to call another application to save the cropped image as a GIF image...

Ram P

Andy

You are really great with charts. Even Now I am confused with respect to your extraction of soource data for the said chart

Ram P

Hi

I was exploring the option of using VBA to achive the said process. Can anyone help me in this?

Thanks

Ram P

Hi Dennis

Thanks for your reply.

Yes it does appear that Export Method is applicable for only charts.

Is there a way to Copy the Userform Image and then export it as JPEG OR GIF IMAGE?

Thanks

Ram P:bouncy:

Hi

I am trying to export a userform as GIF image. Is this possible? I am using the following code, But I get the error in Export Statement.

Sub export_form()
Dim us As Object
abc = ActiveWorkbook.Path
Set us = UserForm1
gifname = InputBox("Enter name for GIF:")
us.Export abc & gifname & ".gif", FilterName:="GIF"
End Sub

You can find any links in the file by typing ! in the Find feature of Excel. Then go to those specific cells and then remove the links. If you still have links in the file, there are many free add-ins available on the net that can perform this operation.

Ram P

You can do it like the following .

=Sheet1!$D$2

select the chart title and type the required formula in the formula bar

Ram P

Aaron

I did check out your site also. Ites really informative. Probably some experts can give me the methodology of how this is made. I am raking my brains for the last 48 hours!!!

Ram P

I was able to obtain a file that shows me 3D Charts. But I am unable to figure it out how it is been done. Can anyone have a look at it and then tell me how it is done....

I shall be very much helpful to your efforts.

Ram P

Try selecting data series in the first department and change the chart type. Else you can add the same data to all the departments and then change the chart type. Hope this helps.

Ram P

You need to add a new series to the said graph and change the chart type for the added series to Line or XY Scatter.

Ram P

Recenly A Friend of mine came with a peculiar requirement. He would like to have floating points in 3D Space. He has x, y, z dimensions. For specific x,y,z combintation he wanted to have a point in space on a graph. Is this possible in XL. I tried various combinations but was unsuccessful. Hope the experts in here can guide me.

Thanks

Ram P

I figured out all the available shortcuts after some cearch in MSN Site. Here is the link. Probably it shall be helpful to others.

http://www.microsoft.com/enabl…yboard/keyboardsearch.asp

Thanks

Ram P

Hi

Can anyone let me know what are the various key board short cuts in Word?

Thanks

Ram P

Good to have a new forum from Dave. Hope this shall be successful in its endeavour

Ram P