+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Formatting a chart axis

  1. #1
    Registered User
    Join Date
    11-15-2011
    Location
    weiser, idaho
    MS-Off Ver
    Excel 2007
    Posts
    12

    Post Formatting a chart axis

    I have a chart with a vertical axis that ranges between 0 and 400%.

    I would like to format matt the 100% line and text a different color so it stands out over the other values listed on the axis.

    Is there a way to do this?

  2. #2
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Formatting a chart axis

    I'd suggest adding a new series that is always 100%, and use a "highlighted" color for it. See this always informative page from Andy Pope's site for some technical details that will make it easier for you:
    http://www.andypope.info/charts/hiliteaxislabels.htm
    Is your code running too slowly?
    Does your workbook or database have a bunch of duplicate pieces of data?
    Have a look at this article to learn the best ways to set up your projects.
    It will save both time and effort in the long run!


    Dave

  3. #3
    Registered User
    Join Date
    11-15-2011
    Location
    weiser, idaho
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Formatting a chart axis

    Thanks, I aprreciate the help

+ 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