data left and right of x axis

  • Thread starter Thread starter vkada1
  • Start date Start date
V

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