PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Category axis for negative numbers

Reply

Category axis for negative numbers

 
Thread Tools Rate Thread
Old 10-02-2004, 10:45 PM   #1
Andrea
Guest
 
Posts: n/a
Default Category axis for negative numbers


I have created a column graph that consists of all
negative numbers. How do I get the category axis above
the 0 mark. Since all the numbers are negative, the
category descriptions are appearing in the upper middle
of the graph and not outside the graph.
  Reply With Quote
Old 11-02-2004, 04:06 PM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: Category axis for negative numbers

Andrea -

Double click on the axis, click on the Patterns tab. Select the High or
Low option for Category Labels (bottom right of the dialog).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Andrea wrote:

> I have created a column graph that consists of all
> negative numbers. How do I get the category axis above
> the 0 mark. Since all the numbers are negative, the
> category descriptions are appearing in the upper middle
> of the graph and not outside the graph.


  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