How do I plot negative bars/numbers BELOW the main axis in Excel

M

Maciel

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.
 
J

Jon Peltier

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
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Graphing Negative Time 1
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Employee Schedule not plotting properly - chart type / data series not correct 0
Error bars plot black triangles 6
multiple series bar and line chart 2
2007 move axis label & add zero line 1
Chart does not render plotted points correctly, data comes from a 3
Convert Error Bars to Series and Colour 1

Top