If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 news 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 04:19 AM |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
Combined bar and line chart (two Y axis) how to make excel know which data goes where | Bugjam1999 | Charts and Charting | 2 | September 22nd, 2005 11:57 AM |
excel should make it easier to have a 1 to 1 plot area in chart | Andy | Charts and Charting | 2 | September 2nd, 2005 03:42 AM |
Two axis Bar charts in Excel | Harvey Randell | Setting up and Configuration | 0 | December 19th, 2003 02:09 PM |