H
hugh jass
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
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