data left and right of x axis

[vkada1]

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!!!!!

 

[Jon Peltier]

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