Excel Data Labels 1

[kim00]

I use pie charts in a monthly newsletter and sometimes I need to manipulate the labels to make them fit better. If I physically put in a carriage return the labels are no longer dynamic. Is there a way for me to edit the labels like this and still be able to rely on the labels updating in the pie chart?

Any help would be great ...thanks kim

 

[SkipVought]

Hi,

Try putting a carriage return in your Category source data -- alt+[Enter]

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[kim00]

Skip - I hadn't thought of that at all and it works - thanks! But there's one problem - the category source data is also a linked table in the newsletter (next to the pie chart - I know it seems redundant but I can't change that). So when I copy and paste/link the table with the categories into Pagemaker, it comes in with the carriage return.

If it's impossible I'm sure I can work around it with your original solution - thank you again for that.

...kim

 

[SkipVought]

Can't have it both ways, can you.

Make another row/column of cells to use for the data lables that reference the source data table, but ALSO have the alt+[Enter]

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[kim00]

Thanks Skip! That works. Now don't kill me but after doing that I was getting the little character representing a page break. I stole this macro from another post to get rid of the character and when I run the macro my link breaks - is there any way to maintain the link and get rid of that character?

This is the code I added:

Sub RemoveCR()
Dim Cel As Range
For Each Cel In Range("A12:A17")
Cel.Value = Replace(Cel, Chr(10), "")
Next
End Sub

I appreciate your patience - my macro knowledge is extremely limited.

Thanks kim

 

[SkipVought]

What link breaks?

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[kim00]

Skip - I'm sorry - I meant the carriage return.

 

[SkipVought]

I don't understand.

First you want the link/CR, then you don't want the link/CR????

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[fkegley]

kim00 the symbol you're trying to get rid of IS the carriage return that you just inserted. It has to be there or there's no way Excel knows to do a CarriageReturn at that point in the text.

Frank kegley

 

[kim00]

Oh man - I'm killing you. I think I'm all set now. I need the carriage returns in the categories that are around the pies but not on the categories that are in the linked table.

I showed my boss our little tête-à-tête and he was thrilled. He put the carriage returns in the categories that went to the pies then used the second column (both of which you suggested) where he put a "=CLEAN()" formula to get rid of the non-printing characters which represented the line breaks.

You deserve a medal. Thank you again for all your help and perseverance. I gave you a star but I don't know where it went.

 

[SkipVought]

Did you try as I suggested --

making a set of separate references to source data table the for the Data Label that INCLUDES the alt+[Enter]

That way when the source data changes the separate references ALSO change but include the CR for your data Lables

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[kim00]

Yes and thank you again. It's perfect. And thanks fkegley - this whole process was extremely painful for Skip. But you've changed my life (I'm sure you've heard that before).

...kim