Format alignment for XLS 2007 in the chart data

[vcff]

I have a chart with the chart data displayed. However, it did not show the
full figure (19576.35 was shown as 195) due to the size of the chart. How can
I format the digit figure to vertical in order to show all the digits.

Thank with Regards

 

[Jon Peltier]

Presumably these are the horizontal axis tick labels?

Select the axis or its tick labels and press CTRL+1 (numeral one) to open
the Format Axis dialog. Click on the Alignment button on the left side of
the dialog, then choose one of the options in the Text Direction dropdown.

- Jon

 

[vcff]

Thanks for your reply.

No, I am refering to the DATA TABLE below the chart. I am able to see the
complete figure (19576.35) unless I expand the chart to the right. However, I
wish to maintain only a small chart on the worksheet. Any help will
appreciated.

Tnks

 

[Jon Peltier]

These data tables are pretty inflexible. I generally avoid them in favor of
customized tables in the worksheet.

- Jon

 

[vcff]

ok anyway thanks for your reply

These data tables are pretty inflexible. I generally avoid them in favor of
customized tables in the worksheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______