Excel 2007 : getting rid of word wrap in data table

[schentor]

How do I prevent the headings in a data table attached to a chart from wrapping? I created a chart and set it to display the data table. The headings are years, and right now the last digit of each year is displayed on a separate line. I attached an image of the chart. Resizing the chart and changing the font size in the data table don't work. I also tried increasing the intervals between tick marks, but that doesn't stop the wrapping, either. The default word wrap option in page layout is already turned off.

[Maistrye]

Hi,

You might try one of the following two things:

1. Change the orientation on the X-axis so that it is at 90 degrees (so the text is straight upward).

2. Change the number format for the X-axis to only show the last two digits of the year.

S

[schentor]

Stupid me... I fixed it by enlarging the chart area much more than I had tried previously. Now, when I copy the chart into the poster I'm making, I just need to crop out the whitespace.