ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   pivot chart formatting? (https://www.excelbanter.com/excel-programming/277063-pivot-chart-formatting.html)

hugh jass

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...




All times are GMT +1. The time now is 01:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com