+ Reply to Thread
Results 1 to 3 of 3

Chart Formatting

  1. #1
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Oxford
    MS-Off Ver
    Excel 2003, 2007 and 2010
    Posts
    120

    Exclamation Chart Formatting

    Hey all,

    I have a Chart that has two series, one showing a standard hours and another showing worked hours. is there away to change the colour of the second series if the amount is less or greater than the first series?

    So if they have worked over the standard hours the bar changes green, if they are under it is red.

    I am trying to do this in 2007

    any help would be great.

    thanks

    Tom
    Last edited by t0m46; 07-07-2010 at 09:21 AM.

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,444

    Re: Excel Chart Formating

    Hi,

    There's a great tutorial here
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Oxford
    MS-Off Ver
    Excel 2003, 2007 and 2010
    Posts
    120

    Re: Excel Chart Formating

    Hey,

    Thanks really good link.

    Tom

+ 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