Excel 2007 : bar chart - series name overlaps data

Hi all,

I'm trying to put together a bar chart. It's meant to have data to both sides of the vertical axis. The problem I'm running into is that the series names sit overtop of the negative value bars. I've been trying to move them to the side, but have had no success. I've found the Layout tab in chart options, but I can't find an option that lets me shift the series names.

The file is attached. Thanks for this great forum. It's already answered so many questions.

...and not long after posting I found a solution. Select format axis, axis options, axis labels and chose either high or low depending on which side of the y-axis you want the series names.