Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Maciel
 
Posts: n/a
Default How do I plot negative bars/numbers BELOW the main axis in Excel

I want to be able to have bars on the chart plot above and below a main axis
line (zero). Can anyone tell me how to do that. I found an invert if negative
button but nothing happens when I choose it.
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default How do I plot negative bars/numbers BELOW the main axis in Excel

Invert if negative changes the colors of the bars/columns. See this page on
Andy Pope's site for the most lucid discussion I've read about it:

http://andypope.info/charts/Invertneg.htm

If you have positive and negative numbers and you create a column chart
using them, the positive columns will stretch up from the horizontal axis,
and the negative ones will hang down from the axis.

If you're having trouble, describe the data, the steps you've taken, and the
result, and why it differs from what you'd expect.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Maciel" wrote in message
...
I want to be able to have bars on the chart plot above and below a main
axis
line (zero). Can anyone tell me how to do that. I found an invert if
negative
button but nothing happens when I choose it.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make a 3-dimensional plot in Excel? John W. Mordosky Charts and Charting in Excel 6 April 3rd 23 06:58 PM
Move the Y axis below negative values Vic Mel Charts and Charting in Excel 2 January 14th 06 03:24 PM
how to add a second x axis with same Y axis value in one plot Mike Charts and Charting in Excel 1 October 19th 05 08:42 AM
Chaning X axis scale in Excel 2003 wendythelwell Charts and Charting in Excel 2 August 9th 05 02:35 PM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 07:25 PM


All times are GMT +1. The time now is 05:40 PM.

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

About Us

"It's about Microsoft Excel"