+ Reply to Thread
Results 1 to 2 of 2

Changing individual axis labels on the same axis (vba?)

  1. #1
    Registered User
    Join Date
    05-24-2010
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Changing individual axis labels on the same axis (vba?)

    Hi,

    I have a stacked bar chart with about 30 horizontal bars and a corresponding y-axis. Half of these bars are previous data values for comparison. I would like to format the y-axis labels that start with "previous" in italics (or a different colour).

    In addition, if possible, I would like to have the bars which corresponde to the axis labels in italics thinner than the other bars.

    Any help would be much appreciated. (Preference would be a way to do this with vba if possible).

    Many thanks,

    sikey
    Last edited by sikey; 08-04-2010 at 06:52 AM.

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

    Re: Changing individual axis labels on the same axis (vba?)

    Formatting of axis labels applys to all labels.
    To format individual axis labels you will need to rerecrate the axis labels using a dummy series' data labels.
    Cheers
    Andy
    www.andypope.info

+ 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