Bar graph offset

i have seen variations of this question on but i am curious about my particular graph.

i have a bar graph which graphs percentage values. Some are positive and some are negative. Because some of the data is negative, the data labels are "encroaching" on to the graph (even at maximum offset, i.e. 1000).

I need them not to.

I know you can adjust the "Category X Crosses Axis at" value to move the data labels off the chart graphic, but this changes the view of the negative percentages. Previously, the negative values "grew" downward from 0%, where as adjusting the axis makes them grow upward from say -.15%.

I need the negatives to grow downward AND have the data labels off the chart.

Any thoughts???

Thanks for looking,
Greg

viola!

thanks a bunch.