Posts by lambuhere1

Probably others can shed more light on this. But This is what I would do.

For each series collection, I shall search for the data value. And if it is zero, then don't plot that series.

I may be wrong, but this gives the direction

Thanks

Hi

Do you mid attaching a sample file for us to learn. We are never old to learn new things!

Thanks:cheers:

Great Wizard "Andy" back to charts.

Good to hear from you Andy

Your site is worth a visit.

Have a Great Weekend

:beergrin:

How about using data filter autofilter.

select blanks

select all the listed rows and then press delete row.

Hope this helps.

Paddy

Thanks for the link. Its worth paying a visit.

:thumbcoo:

If you want to lable the data series with names in different rows or columns, You may need a bit of VBA. Else, You can get the required data from data-labels.

Thanks

Did you have a look at Get External Data.

Probably this should guide you.

Thanks

I use the following code to copy each chart onto each slide on a blank Power Point Presentation. I hope you can make the changes to meet your requirements. Note that the charts in Power Point are NOT linked to the charts in Excel. For that we require to develop new logic and code.

Dim oppt As New PowerPoint.Application
Dim pptpres As Presentation
Dim pptslide As Slide
Dim ch As Chart
Dim wkb As Workbook
Dim strtempwkb As String

'build a temporary workbook

this_path = ActiveWorkbook.Path
strtempwkb = this_path + "\" + "tempwkb.xls"

'create a new presentation
oppt.Visible = msoTrue

Set pptpres = oppt.Presentations.Add
With pptpres.Slides

lheight = pptpres.PageSetup.SlideHeight

lwidth = pptpres.PageSetup.SlideWidth


'place each chart on slide
For Each ch In ActiveWorkbook.Charts

'copy the chart to a new workbook
ch.Copy
Set wkb = ActiveWorkbook

wkb.SaveAs strtempwkb

Set pptslide = .Add(.Count + 1, ppLayoutBlank)
pptslide.Shapes.AddOLEObject Left:=(lwidth ), Top:=(lheight ), Width:=(lwidth ), Height:=(lheight), Filename:=strtempwkb, link:=msoFalse


'close temp workbook and delete it
wkb.Close savechanges:=msoFalse
Kill strtempwkb
Next ch

Try the option of recording a macro when you make a chart. It gives you a idea about your grid lines, plot area and all other concepts about charts. And if you still face any difficulty, so let us know.

I learnt a lot this way.

Thanks

Yes, You can do it.

Do you mind attaching a sample Excel file for our reference. I shall try to work it out for you.

Thanks

How about using chr(13) ?

Have a look at http://www.tushar-mehta.com

You may find the needful chart in there.

Xl-Dennis

Thanks for your reply.

I did take a look at your link.

And instead of that, I used the "mail merge" concept in outlook. This works for me.

But I want to remove the message box whenever I send a mail. And I would like to have a read receipt for each mail. Presently I am not abel to.

Can you help.

All information I have obtained is by typing "sending bulk mail " in outlook help.

:cheers:

This is probably experts in here can answer.

We generally communicate through our employees in bulk i.e., all staff mail. Instead of that, what we are looking for is a way to program MS outlook, such that for all the names in To: Cc: or Bcc: it sends individual mails with their names extracted from the name list and then send it to the listed name.

For e.g.,

In your To: You have names, A, B, C etc.

In the message body, you type

Dear

Body

Thanks

Now, when we press send, Outlook needs to be programmed in such a way it sends individual mails to A, or B, or C, by extracting the name from the To: and pasting it after Dear:

In the above case, Outlook should send 3 mails to person A, B, C.

Person A will receive a message as

Dear A

Person B will receive a message as

Dear B

And so on.

I hope you can solve this dilemma of ours.

Thanks a lot for your help.

Ram P

Is it due to the fact that your file Full name is Exceeding 256 characters?

Check it out.

When you paste the Excel Table in Word,

Use the Paste Special Option, Check Paste Link and choose Worksheet Object.

Now whenever your data gets updated in your Excel file, this gets reflected in your Word doc.

Thanks:guitar:

Odysseus

I am interested to know the answer for your question "Who owns the fish". I did it manually and I wanted to tally with the correct answer. Would you be kind enough to supply the correct answer for this question.

Thanks

Goto-tools-macro-security

Check it low.

Caution: Keep the security levels to medium, such that untrusted macros do not run on your machine and hijack it.

If you know that all the macros running on your machine are from trusted source, keep the security level to low.
:nono:

Are you looking something like this??

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

Probably this should guide you.

Dave,

You are right on target. I shall use the code you provided for this aspect.

Thanks a lot for your help.

Ram P:cheers: