Come on PowerPoint MVPs!

  • Thread starter Thread starter Justin
  • Start date Start date
J

Justin

Okay, I know this can be done because I saw several instances of it today!

I want to be able to manually break the series titles on the X-Axis of a
chart (not by adding text boxes in the presentation) but by doing it in the
MS Graph data table.
I know for a fact that there IS a way to do this because I saw it several
times today in an existing presentation but no one knew who did it or how it
was done.
In the cell itself there is a character shaped like a square. It's placed
directly in-between the lines where it breaks occurs but the 'square' looked
as if it was sitting on top of the tow text lines that it was breaking.,
kind of overlapping them both, almost as if it had been placed on top of
them.

How can I recreate this result? Is there an Alt + character code? Does it
need to be created in another program? (And yes, I already tried copying
wrapped cells from Excel, that doesn't work.)

I've seen this so I know it can be done. Come on MVPs if anyone knows this
you guys do?

Thanks,

Justin
 
Justin,
You need to provide a carraige return character. Alt+Enter does not work in MS Graph though.

But, you can type it out in a Excel cell, create the break with Alt+Enter and then paste the contents to the MS graph datasheet.

e.g. In an Excel cell type this... (Press keyboard buttons for contents in braces)
Link {Alt+Enter} Information

Regards
Shyam Pillai

http://www.mvps.org/skp


----- Justin wrote: -----

Okay, I know this can be done because I saw several instances of it today!

I want to be able to manually break the series titles on the X-Axis of a
chart (not by adding text boxes in the presentation) but by doing it in the
MS Graph data table.
I know for a fact that there IS a way to do this because I saw it several
times today in an existing presentation but no one knew who did it or how it
was done.
In the cell itself there is a character shaped like a square. It's placed
directly in-between the lines where it breaks occurs but the 'square' looked
as if it was sitting on top of the tow text lines that it was breaking.,
kind of overlapping them both, almost as if it had been placed on top of
them.

How can I recreate this result? Is there an Alt + character code? Does it
need to be created in another program? (And yes, I already tried copying
wrapped cells from Excel, that doesn't work.)

I've seen this so I know it can be done. Come on MVPs if anyone knows this
you guys do?

Thanks,

Justin
 
That works!

If only we could find out what the actual character is (e.g. Alt something) then it could be entered manually perhaps

Cheers
TAJ Simmons
microsoft powerpoint mvp

awesome - powerpoint backgrounds,
free powerpoint templates, tutorials, hints and tips etc
http://www.powerpointbackgrounds.com
 
It's not a secret. Different programs honor different codes:
CR=10
LF=13
LineBreak=11

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Thanks Shyam,
That worked. I thought I'd tried that. Guess it's not the same as using
the wrap in cell function. in Excel.

Thanks a million!

Justin


Shyam Pillai said:
Justin,
You need to provide a carraige return character. Alt+Enter does not work in MS Graph though.

But, you can type it out in a Excel cell, create the break with Alt+Enter
Click to expand...
and then paste the contents to the MS graph datasheet.
 
Well, this is proof that different programs interpret alt+ codes
differently. Alt +11 didn't actually yield a question mark in MS Graph, it
yielded the "Male" symbol (as in the circle with an arrow sticking out of
it).

Thanks
 
Back
Top