data left and right of x axis
tryingt o make a bar chart with values 8,8,3,9,3 i need values under 5 to be
left of vertical axis only and values over 5 to be right... so eight would be 3 places right three would be two places left hope that makes sense.. i have NO idea how to do this HELP!!!!! |
data left and right of x axis
Right click on the other axis, choose Format...
On the tab that allows you to enter scale parameters, find 'Axis Crosses At' or perhaps 'Category Axis Crosses At' (depending on version) and enter 5 in the box. This will position the crossing axis at 5. The bars will start at this vertical line and move left or right to the values. If you want the bars still to begin at zero, consider adding a line: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "vkada1" wrote in message ... tryingt o make a bar chart with values 8,8,3,9,3 i need values under 5 to be left of vertical axis only and values over 5 to be right... so eight would be 3 places right three would be two places left hope that makes sense.. i have NO idea how to do this HELP!!!!! |
All times are GMT +1. The time now is 09:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com