ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   wrap text in a chart data table (https://www.excelbanter.com/charts-charting-excel/220418-wrap-text-chart-data-table.html)

Warren B

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?

Jon Peltier

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?




rami

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?





Jon Peltier

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?








All times are GMT +1. The time now is 08:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com