PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Axis Issues

Reply

Axis Issues

 
Thread Tools Rate Thread
Old 11-07-2008, 07:54 PM   #1
DALLAS6570
Guest
 
Posts: n/a
Default Axis Issues



I am having a problem that I think has a simple fix, but I can't figure
it out.

I have created a simple bar graph where one bar has a negative dollar
value and the rest have positive vales.
The problem is that I can't figure out how to leave the x axis at $0.00
value where it intersects the Y axis and have the column labels show at
the bottom of the chart.

If that makes no sense please see attached picture!!

If anyone can help I would be much appreciated!!


+-------------------------------------------------------------------+
|Filename: cHARTTTTTTT.JPG |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=116|
+-------------------------------------------------------------------+



--
DALLAS6570
  Reply With Quote
Old 12-07-2008, 04:02 AM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: Axis Issues

Don't change where the category (X) axis crosses the value (Y) axis. Format
the category (X) axis, select the "Low" option for the tick labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"DALLAS6570" <johnkissamyassa@hotmail.com.invalid> wrote in message
newsALLAS6570.2bd962c@excelbanter.com...
>
> I am having a problem that I think has a simple fix, but I can't figure
> it out.
>
> I have created a simple bar graph where one bar has a negative dollar
> value and the rest have positive vales.
> The problem is that I can't figure out how to leave the x axis at $0.00
> value where it intersects the Y axis and have the column labels show at
> the bottom of the chart.
>
> If that makes no sense please see attached picture!!
>
> If anyone can help I would be much appreciated!!
>
>
> +-------------------------------------------------------------------+
> |Filename: cHARTTTTTTT.JPG |
> |Download: http://www.excelbanter.com/attachment.php?attachmentid=116|
> +-------------------------------------------------------------------+
>
>
>
> --
> DALLAS6570



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

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 On
HTML code is Off