pivot chart formatting?

Hello All,
I am having fun getting pivot tables to show me simplified views of my data.
Pretty happy with everything, except for minor details on formatting the
chart. It seems that I can right-click on any part of the chart to format
that specific item (eg. y-axis, gridlines, chart background, data table...).
One thing that I can't find a way to format is the x-axis sub-category text.
I am showing a column chart of aircraft serviced by type(main category),
date(sub category) and location(divides the columns into classes). When I
start with the chart, the date appears legible, aligned vertically below the
columns. However, when I add a data table, the dates change to horizontal
alignment. It seems that this is to fit the entire display onto one page,
so I tried to change to portrait orientation and to change to different
paper sizes, but this doesn't help.
Other than excluding the data table, I can't think of anything else... Can
anyone help?
thanks, hj
--
______________________
please remove the obvious from my email...

Hugh -

Here's my rant on Data Tables:

http://pubs.logicalexpressions.com/P...?ID=209#jon021

They seem like a fine idea, but just never get implemented in a way that
make them worth the hassle. I usually make a table in the cells near
the chart, and format it to my liking.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

hugh jass wrote:
Hello All,
I am having fun getting pivot tables to show me simplified views of my data.
Pretty happy with everything, except for minor details on formatting the
chart. It seems that I can right-click on any part of the chart to format
that specific item (eg. y-axis, gridlines, chart background, data table...).
One thing that I can't find a way to format is the x-axis sub-category text.
I am showing a column chart of aircraft serviced by type(main category),
date(sub category) and location(divides the columns into classes). When I
start with the chart, the date appears legible, aligned vertically below the
columns. However, when I add a data table, the dates change to horizontal
alignment. It seems that this is to fit the entire display onto one page,
so I tried to change to portrait orientation and to change to different
paper sizes, but this doesn't help.
Other than excluding the data table, I can't think of anything else... Can
anyone help?
thanks, hj