+ Reply to Thread
Results 1 to 4 of 4

fill in areas between graphs

  1. #1
    Registered User
    Join Date
    03-04-2016
    Location
    Coventry, England
    MS-Off Ver
    2013
    Posts
    8

    fill in areas between graphs

    Hi everyone,

    I have few linear plots running more or less parallel to each other in one axis. Now I want to fill the areas between the plots with different colours (one colour between 2 lines, another colour between another 2 lines).
    I tried the area plot but it doesn't seem to work the way I want.

    Thank you very much for any suggestions,
    Dominika

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: fill in areas between graphs

    Hello Dominika

    You've not given us much to go on as regards your data but take a look at the link below it gives a number of examples of filling in between an XY Scatter chart, if that's what you're using.

    http://peltiertech.com/fill-under-be...n-excel-chart/

  3. #3
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,397

    Re: fill in areas between graphs

    Dominika,

    Try the attached, which fills the gaps between the different line values with dofferent colours.

    HOpe this helps?

    Ochimus
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-04-2016
    Location
    Coventry, England
    MS-Off Ver
    2013
    Posts
    8

    Re: fill in areas between graphs

    Thank you! I found the solution.

+ 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. Fill areas between 3 line graphs
    By matrex in forum Excel General
    Replies: 11
    Last Post: 04-29-2015, 01:23 PM
  2. Replies: 1
    Last Post: 01-23-2014, 09:31 AM
  3. [SOLVED] Count rows between two areas in a collection/selection of multiple areas
    By JTwrk in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-02-2012, 10:38 AM
  4. How to resize plot areas so that graphs are uniform?
    By Silverbrook in forum Excel Charting & Pivots
    Replies: 18
    Last Post: 05-12-2012, 01:59 AM
  5. automatic drawing of shapes (areas) into graphs based on data values?
    By 77anders in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-15-2009, 05:51 PM
  6. How do I fill the up/down bars areas with solid color
    By Seaborn in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-28-2007, 05:59 PM
  7. Excel include more colours for fill & graphs
    By Bec in forum Excel General
    Replies: 1
    Last Post: 03-26-2006, 10:55 PM
  8. Fill Options for XY Graphs
    By Paul in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-12-2005, 05:05 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