Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Apr 2008
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    y axis labels (excel 2003)

    I want to have the labels for the bar graph appear at the far left. I want to keep the bars themselves centered based on the x axis. Is it possible to add a secondary dummy y just for labels?
    Attached Files Attached Files

  2. #2
    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: y axis labels (excel 2003)

    Instead of using a dummy label, you can just add the category labels to the "low end" of the chart by dbl-clicking the Y-Axis, going to patterns (tab), and selecting "Low" on "Tick Mark Labels"

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: y axis labels (excel 2003)

    That's much easier! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: y axis labels (excel 2003)

    Added: please see Steve's reply - he has a much easier solution!

    You can add a dummy series to the chart; you can use the same data as that of the Dimension series (and make the series transparent), or just an empty data range.
    If you want to keep the chart legend, click on the legend, then on the dummy series in the legend and delete it.
    Specify that the dummy series uses the secondary value axis.
    This enables you to specify a secondary category axis too, in Chart | Chart Options...
    Then format the secondary value axis to have a minimum of -15 and let the category axis cross it at -15. You now have category labels on the left.
    Next, format the primary category axis to have no tick labels; this hides the category labels for this axis.
    Finally, you can delete the secondary value axis (or just hide its tick labels, if you prefer).

    See attached version.
    Attached Files Attached Files

  5. #5
    Lounger
    Join Date
    Apr 2008
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: y axis labels (excel 2003)

    Thank you both- this was very helpful and very informative as well!

Posting Permissions

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