Results 1 to 14 of 14

Multiple Shading within a Scatter Chart

Threaded View

  1. #1
    Registered User
    Join Date
    01-16-2013
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Multiple Shading within a Scatter Chart

    I'm working on a criteria matrix in Excel 2010 that automatically plots a single member in a Scatter Chart based on the two values. There are 4 suppliers listed in Column D starting in cell D4 thru D7. The "x" value is listed in Column E starting in cell E4 thru E7. The "y" value is listed in Column F starting in cell F4 thru F7.

    The scatter chart will plot the points correctly, however, there are two issues:
    1) If I try to insert a data label using the "Series Name," or in this case, the supplier's name, it will lists ALL of the suppliers Column D. It will not list the single supplier listed in cell D4.
    2) The scatter chart appears with gridlines as a 4x4 matrix with a total of 16 cells. The "x" and "y" axis both start at 0 and go to 4. I can shade the entire chart one color. However, I want to shade some of the cells with darker and lighter shades.

    Any thoughts on the two items listed above?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Shading periods in a scatter plot
    By Carlos Menegocci in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-12-2012, 10:46 AM
  2. XY (Scatter) chart - 1 series/multiple color
    By KHUY in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2012, 06:41 AM
  3. Shading a section under a scatter graph?
    By I-Like-Excel in forum Excel General
    Replies: 6
    Last Post: 05-09-2011, 09:13 AM
  4. multiple lines / curves on scatter chart?
    By lightecho in forum Excel General
    Replies: 1
    Last Post: 09-03-2007, 12:19 PM
  5. Shading on a scatter graph
    By strobinson1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-07-2006, 05:10 AM

Tags for this Thread

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