Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
Move the Y axis below negative values | Charts and Charting in Excel | |||
how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
Chaning X axis scale in Excel 2003 | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |