Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Horizontal bar chart data labels (Office 2003)

    I have the attached horiz bar chart. I had to move some of the number so they didn't overlap the labels but I also need to move the labels out of the bar.

    Is there a way I can do this, am i using the wrong type of bar graph to depict this data

    Also, is there a utility that can be used to fix the labels and data points so they are readable?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Horizontal bar chart data labels (Office 2003)

    Hi there

    It seems a bit difficult with this format. I tried to format the axis. On the Alignment tab I offset to the maximum level of 1000, sadly this did not move the data far enough out. However by changing the chart to a 3d Bar Chart it was able to reassign the data tags like below
    Jerry

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Horizontal bar chart data labels (Office 2003)

    If you select the vertical (category) axis you can set the "Tick Mark Labels" either to "Low" (all labels will be on the left side of the chart) or "High" (all on the right).

    You should have a look at Bob Bovey's handy <img src=/S/free.gif border=0 alt=free width=30 height=15> utility, the XY Chart Labeler at appspro.com. Although the name implies that it will be good for X-Y charts, it provides useful utilities for all sorts of charts.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Horizontal bar chart data labels (Office 2003)

    The way I would do it:
    dbl-click the verical axis(get the Format axis dialog)
    pattern(tab)
    Click "Low" for "Tick Mark Labels"
    <ok>

    Dbl-click a "data Label" (get the Format data labels dialog)
    Alignment (tab)
    Label position - Choose "Outside End"
    <ok>

    Steve

  5. #5
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Horizontal bar chart data labels (Office 2003)

    This is a tremendous help! thank you very much

Posting Permissions

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