![]() |
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