ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   "X" Axis in Excel Charts (https://www.excelbanter.com/charts-charting-excel/485-%22x%22-axis-excel-charts.html)

LPS

"X" Axis in Excel Charts
 
Using Excel 2000 in a Windows 2000 O/S, is it possible to move the "X" axis
fromthe bottom of the chart to the top?

Thank you.
--
LPS

Andy Pope

Hi,

To move the labels to the top double click the x-axis and on the
Patterns tab select "Tick Mark Labels" High.

Cheers
Andy

LPS wrote:
Using Excel 2000 in a Windows 2000 O/S, is it possible to move the "X" axis
fromthe bottom of the chart to the top?

Thank you.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

LPS

Hi Andy. Thank you for your suggestion. So only the labels can moved, not
the axis line?

L.

"Andy Pope" wrote:

Hi,

To move the labels to the top double click the x-axis and on the
Patterns tab select "Tick Mark Labels" High.

Cheers
Andy

LPS wrote:
Using Excel 2000 in a Windows 2000 O/S, is it possible to move the "X" axis
fromthe bottom of the chart to the top?

Thank you.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


Andy Pope

No, you can move the axis.
Double click the y-axis and on the scale tab select
Category (X) axis crosses at maximum value.

Cheers
Andy

LPS wrote:
Hi Andy. Thank you for your suggestion. So only the labels can moved, not
the axis line?

L.

"Andy Pope" wrote:


Hi,

To move the labels to the top double click the x-axis and on the
Patterns tab select "Tick Mark Labels" High.

Cheers
Andy

LPS wrote:

Using Excel 2000 in a Windows 2000 O/S, is it possible to move the "X" axis
fromthe bottom of the chart to the top?

Thank you.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 09:45 AM.

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