+ Reply to Thread
Results 1 to 4 of 4

Trying to apply fill color between two line charts and plot a third line between them.

  1. #1
    Registered User
    Join Date
    06-23-2012
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2003
    Posts
    12

    Trying to apply fill color between two line charts and plot a third line between them.

    Dear members,

    I have two competitors with competitor A usually higher than my company's prices and competitor B unusually has lower prices than Trying to apply a fill color between two line charts and plot a third line in the middle of them (my company prices). This will allow me to ascertain if my company prices are closer to comp A. or comp B? A great example of what I am trying to accomplish is:

    http://www.hotelnewsnow.com//media/i..._Hartmann2.gif.

    Does anyone know how to accomplish this? Any help would be greatly appreciated. Thank you.

  2. #2
    Registered User
    Join Date
    08-08-2012
    Location
    PA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Trying to apply fill color between two line charts and plot a third line between them.

    TO do this, I think you can have 2 area charts (one with a white fill color) and then a single line series.

  3. #3
    Registered User
    Join Date
    08-27-2012
    Location
    Taipei, Taiwan
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Trying to apply fill color between two line charts and plot a third line between them.

    use stacked area chart, plotting the third series of value to secondary axes, using line chart.

  4. #4
    Forum Contributor
    Join Date
    02-22-2011
    Location
    Rhône Alpes, France
    MS-Off Ver
    Excel 2007
    Posts
    201

    Re: Trying to apply fill color between two line charts and plot a third line between them.

    Hi,
    For fun, I extract the data coordinates with Adobe Acrobat and calculate each values
    Then insert 2 area charts (one with a white fill color) and a line chart as proposed by syswizard
    See attached the result
    Hope this help
    Best regards
    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