Pivot Chart - Formatting Axis on Data Table

[Max]

I have a pivot chart (standard column chart). I can do a "format axis" on
the x-axis and change the alignment of the labels on the axis.

However when I "Show data table" from the Chart Options, I am not able the
change the alignment of the labels anymore. Is there a way to do this?

I am using Excel 2000, and I tried with no success Excel 2003.

Thanks!

[Jon Peltier]

Data Tables are often frustrating. Alternatives are shown on Tushar
Mehta's site (http://tushar-mehta.com) and John Mansfield's blog
(http://pdbook.com/index.php/excel/ and use Search).

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


Max wrote:

> I have a pivot chart (standard column chart). I can do a "format axis" on
> the x-axis and change the alignment of the labels on the axis.
>
> However when I "Show data table" from the Chart Options, I am not able the
> change the alignment of the labels anymore. Is there a way to do this?
>
> I am using Excel 2000, and I tried with no success Excel 2003.
>
> Thanks!