+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : bar chart - series name overlaps data

  1. #1
    Registered User
    Join Date
    Toronto, Canada
    MS-Off Ver
    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.
    Attached Files Attached Files
    Last edited by Cashew; 08-28-2010 at 04:28 PM. Reason: SOLVED

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1