+ Reply to Thread
Results 1 to 2 of 2

Multi color 1 bar chart

  1. #1
    Registered User
    Join Date
    02-16-2007
    Posts
    5

    Multi color 1 bar chart

    Hello there,

    I never used charts before and I have to admit that I am a little lost

    what I need is a single bar chart for every month in a year, so 12 bars...

    I need grades on my bar... lets say that the bar is set at 200...
    from 0-100, bar must be a certain color (objective not met)
    from 100-150, that portion of bar another color (within objectives)
    over 150, that portion of bar another color (exceeded objectives)

    any help would be appreciated

    thanks,
    Climbo

  2. #2
    Registered User
    Join Date
    02-19-2007
    Posts
    24
    You are going to have to add 3 more columns. One for amount until objective, amount within objective, and amount exceeded. And then use a stacked bar graph to show them on top of each other.

    I attached a sheet with the formulas and chart
    Attached Files Attached Files

+ 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