ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Pivot Chart - Formatting Axis on Data Table (https://www.excelbanter.com/charts-charting-excel/26580-pivot-chart-formatting-axis-data-table.html)

Max

Pivot Chart - Formatting Axis on Data Table
 
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!



All times are GMT +1. The time now is 12:23 AM.

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