+ Reply to Thread
Results 1 to 2 of 2

Horizontal Band Graph with line graph

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    North Carolina, United States
    MS-Off Ver
    Excel 2007
    Posts
    56

    Horizontal Band Graph with line graph

    I'm beyond my expertise (meaning none) of developing a graph that has a horizontal band background using different colors. The horizontal bands are a gauge of where performance is green to yellow to red (best to worst). Inside the graph would need to diagram 8 different performance points. I can get the horizontal background but when I change the vertical axis to what I need to measure I lose the five bands I need.

    I have attached a paper I've created to illustrate what I need (albeit hand drawn). Also, a spreadsheet of what I've gotten. I'm sure what I've done is incorrect!

    The vertical axis represents the highest to lowest performance and the horizontal axis has eight points of performance.

    I need to plot those 8 points as well as an average line of -0.03.

    If there is any help anyone could provide I'd greatly appreciate it!!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Horizontal Band Graph with line graph

    Is this what you are looking for? http://peltiertech.com/excel-charts-...izontal-bands/
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to extend horizontal line on column graph
    By bos1234 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-09-2023, 10:28 PM
  2. Line Graph variable horizontal axis
    By Kat82 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-07-2015, 11:20 PM
  3. [SOLVED] How to add a horizontal line to a graph
    By BNCOXUK in forum Excel General
    Replies: 3
    Last Post: 10-29-2012, 11:20 AM
  4. [SOLVED] How to create Individual Horizontal Line in a Graph
    By dluhut in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 06-07-2012, 03:04 PM
  5. Adding Horizontal line to a graph
    By WhytheQ in forum Excel General
    Replies: 1
    Last Post: 06-14-2006, 09:45 PM
  6. [SOLVED] Possible to Add Horizontal Line to Embedded Graph via VBA?
    By TimSchwaar in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-29-2005, 07:05 PM
  7. Possible to Add Horizontal Line to Embedded Graph via VBA?
    By TimSchwaar in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2005, 07:05 PM

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