Results 1 to 2 of 2

Creating a scatter graph with Red / Amber / Green background coloured plotting area

Threaded View

  1. #1
    Registered User
    Join Date
    09-13-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    15

    Creating a scatter graph with Red / Amber / Green background coloured plotting area

    Hi - I need to create a scatter graph with indexes of 0 - 5 for X and Y, each axis having intervals of one.

    I will be plotting data - all values are integers - for an X value of between 0 and 5 and a Y value of between 0 and 5

    I need the graph to have a background colour fill in each of the 25 squares of either red, amber or green colour with:

    Green coloured 'squares' for product of X and Y of less than 4

    Amber coloured squares for product of X and Y greater than 4 and less than 9

    Red coloured squares for product of X and Y between 10 and 25

    I then need the data to be plotted into the graph..... I have attached a workbook with some sample values and an illustration of the background I am looking for and some of the flexibility that would be ideal....
    Attached Files Attached Files

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