Axis labels on negative values

's Computer Specifications

My chart has positive and negative values. The axis labels appear at
the 0 value. How do I move them to the side of the chart.

--
gailb14
------------------------------------------------------------------------
gailb14's Profile: http://www.excelforum.com/member.php...o&userid=33428
View this thread: http://www.excelforum.com/showthread...hreadid=534154

's Computer Specifications

"gailb14" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> My chart has positive and negative values. The axis labels appear at
> the 0 value. How do I move them to the side of the chart.

Format Axis/ Scale/ Value (X or Y) axis crosses at ...
--
David Biddulph

's Computer Specifications

My chart has -10 -5 0 5 10
The labels are at the 0. I must not understand your instructions
Value Y axis crosses at category (1)
Value Y axis crosses between categories (checked)
Value Y axis crosses at maximum category (checked)

This is not working

--
gailb14
------------------------------------------------------------------------
gailb14's Profile: http://www.excelforum.com/member.php...o&userid=33428
View this thread: http://www.excelforum.com/showthread...hreadid=534154

's Computer Specifications

My chart has -10 -5 0 5 10
The labels are at the 0. I must not understand your instructions
Value Y axis crosses at category (1)
Value Y axis crosses between categories (checked)
Value Y axis crosses at maximum category (checked)

This is not working

--
gailb14
------------------------------------------------------------------------
gailb14's Profile: http://www.excelforum.com/member.php...o&userid=33428
View this thread: http://www.excelforum.com/showthread...hreadid=534154

's Computer Specifications

Hi,

You will find instructions here,
http://www.andypope.info/tips/tip002.htm

Cheers
Andy

gailb14 wrote:
> My chart has positive and negative values. The axis labels appear at
> the 0 value. How do I move them to the side of the chart.
>
>

--

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

's Computer Specifications

"gailb14" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> My chart has -10 -5 0 5 10
> The labels are at the 0. I must not understand your instructions
> Value Y axis crosses at category (1)
> Value Y axis crosses between categories (checked)
> Value Y axis crosses at maximum category (checked)
>
> This is not working

I don't know what sort of chart you're using. You may find that XY scatter
gives you more flexibility.
--
David Biddulph

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data labels along below x axis when y axis has negative values	Andrew	Microsoft Excel Charting	1	3rd Jul 2008 08:36 PM
Negative values on Y axis	DruD	Microsoft Excel Charting	1	3rd Jan 2008 09:03 PM
Negative values in bar chart overlap axis labels.	=?Utf-8?B?Qm9ubnk=?=	Microsoft Excel Charting	1	17th Aug 2006 08:34 AM
how to put x axis values in the chart instead of x axis labels	=?Utf-8?B?U2luY2xhaXI=?=	Microsoft Excel Charting	1	21st Jun 2005 11:04 AM
Labels on Chart with Negative Value Axis	David F. Schrader	Microsoft Excel Charting	6	17th Dec 2004 06:25 PM