A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"X" Axis in Excel Charts



 
 
Thread Tools Display Modes
  #1  
Old January 21st, 2005, 04:33 PM
LPS
external usenet poster
 
Posts: n/a
Default "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
  #2  
Old January 21st, 2005, 05:09 PM
Andy Pope
external usenet poster
 
Posts: n/a
Default

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
  #3  
Old January 21st, 2005, 05:41 PM
LPS
external usenet poster
 
Posts: n/a
Default

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

  #4  
Old January 21st, 2005, 05:49 PM
Andy Pope
external usenet poster
 
Posts: n/a
Default

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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing display order of primary & secondary axes in Excel charts APW in Hou,TX Charts and Charting 1 October 15th, 2004 09:43 AM
Update Presentation with Excel charts and tables Holly Powerpoint 2 August 11th, 2004 06:03 PM
Changing Source File of Linked Excel Charts Brad Bendecl Powerpoint 3 August 4th, 2004 08:44 AM
Excel Charts - Value Y axis scale - locking values to preventchanging Andy Pope Charts and Charting 0 June 22nd, 2004 04:31 PM
"spot color" in Excel charts (for Publisher) Jen Charts and Charting 0 May 19th, 2004 11:45 PM


All times are GMT +1. The time now is 10:41 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.