+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : Axis labels

  1. #1
    Registered User
    Join Date
    08-04-2009
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    4

    Axis labels

    Hi.
    I'm trying to do a chart with a vertical double axis.
    The problem is that I need that the second label is in horizontal (like the first label) and I can't change it.

    Can you help me, please?

    In the attachment is a sample of the chart I'm trying to build. I need that the second axes label (letters) to be displayed in horizontal.

    Thanks for any help
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Axis labels

    When using multi level category labels you can only alter the alignment of the inner most level.

    You can either change the chart type to column instead of bar. Or use a 2d bar chart and display the labels via a dummy xy-scatter series with the data labels linked to cells.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-04-2009
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    4

    Talking Re: Axis labels

    Hi Andy.

    Thanks for your quickly reply. Can you explain me how can I "use a 2d bar chart and display the labels via a dummy xy-scatter series with the data labels linked to cells"

    Thanks

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Axis labels

    Change the chart to 2d bar chart.
    Add new series and change to xy-scatter on the secondary axis. The x values for the points is -1 and the Y position related to the bar position. You will need to enable the secondary Value axis and fix the max value to 32.

    I have left the data marker visible so you can see where the points have been plotted.
    Finally use this free addin to link data labels to cells
    http://www.appspro.com/Utilities/ChartLabeler.htm

    You will not be able to show the data table because of the xy-scatter series.
    If you want the data table go with the column chart type.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-04-2009
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    4

    Thumbs up Re: Axis labels

    Thanks Andy.

    you've solved my problem

    :D

+ 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