Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default wrap text in a chart data table

Hi,

Im have created a graph, which ive had no problem, but i when i click the
option to "show data table" i cannot get the titles to wrap to the box, i
have searched but i cannot find an option to wrap the text as i need it for a
presentation.
I do not want to just simply alter the font size if possible. Is there
anyway of doing this?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default wrap text in a chart data table

Data tables in charts are not flexible, either regarding their contents or
their formatting. You could create a table in the cells near the chart,
include what you want in it, and format it however you like.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Warren B" <Warren wrote in message
...
Hi,

Im have created a graph, which ive had no problem, but i when i click the
option to "show data table" i cannot get the titles to wrap to the box, i
have searched but i cannot find an option to wrap the text as i need it
for a
presentation.
I do not want to just simply alter the font size if possible. Is there
anyway of doing this?



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default wrap text in a chart data table

But why was that functionality available in Excel 2003?!! The chart data
table text used to wrap nicely. Given all the many other stability issues, I
think I'll switch back to Office 2003!

"Jon Peltier" wrote:

Data tables in charts are not flexible, either regarding their contents or
their formatting. You could create a table in the cells near the chart,
include what you want in it, and format it however you like.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Warren B" <Warren wrote in message
...
Hi,

Im have created a graph, which ive had no problem, but i when i click the
option to "show data table" i cannot get the titles to wrap to the box, i
have searched but i cannot find an option to wrap the text as i need it
for a
presentation.
I do not want to just simply alter the font size if possible. Is there
anyway of doing this?




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default wrap text in a chart data table

It's accidental that the functionality was there in 2003. Data Tables have
always been disappointing, and so I have never used them. There are more
important reasons than Data Tables to switch back to 2003.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Rami" wrote in message
...
But why was that functionality available in Excel 2003?!! The chart data
table text used to wrap nicely. Given all the many other stability
issues, I
think I'll switch back to Office 2003!

"Jon Peltier" wrote:

Data tables in charts are not flexible, either regarding their contents
or
their formatting. You could create a table in the cells near the chart,
include what you want in it, and format it however you like.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Warren B" <Warren wrote in message
...
Hi,

Im have created a graph, which ive had no problem, but i when i click
the
option to "show data table" i cannot get the titles to wrap to the box,
i
have searched but i cannot find an option to wrap the text as i need it
for a
presentation.
I do not want to just simply alter the font size if possible. Is there
anyway of doing this?






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Long Text Won't Wrap Chart X Axis RoArmstrong Charts and Charting in Excel 3 May 3rd 23 05:08 PM
How do I get date/time to wrap (format - wrap text doesn't work)? Alex Excel Discussion (Misc queries) 3 April 4th 23 02:29 PM
wrap text function causes data to disappear in cell (visually only DaveT Excel Discussion (Misc queries) 17 November 23rd 17 06:59 PM
How to unhide data in cells that have the text-wrap formatting app Janet Shinn Excel Discussion (Misc queries) 3 July 25th 07 10:56 PM
How do I wrap text in the legend key of a data table in a graph? sarah_tennessee Charts and Charting in Excel 1 March 30th 06 01:03 AM


All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"