+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : Horizontal Bar Chart - Vary the relative size/proportion of bar area and label area

  1. #1
    Registered User
    Join Date
    02-28-2012
    Location
    Sydney Australia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Horizontal Bar Chart - Vary the relative size/proportion of bar area and label area

    My Excel skills are rudimentary, so please be tolerant.

    I have produced an Excel horizontal bar chart and I wish to reduce the proportion of the chart used for the bars and increase the proportion used by labels.

    I have long labels and only require short bars.

    When I select the top left of the bar area and drag it to the right, it also drags the label area without changing its size. I end up with shrunken bars and labels that have not changed length.

    I have tried changing chart area and plot area settings without success.

    How do I change the proportion of the horizontal bar chart used by the bars & the labels?

    A quick response would be very helpful & much appreciated.
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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