View original (French)

[Excel] color between two curves

rediriger-ccm Posted messages 37 Status Member -  
 Mario -
Hello!

I have 2 curves in Excel of the type: y=f(x)

I would like to color the area between these two curves in red, how can I do that?

Thank you!

1 answer

  1. brezel
     
    Assuming curve A is above curve B.
    Create a chart with the following data series (in order):
    - curve B
    - curve A-B
    Choose "chart type": stacked areas. Choose "no fill" for the bottom area and red fill for the area between the curves.

    For the case of two curves A and B that cross, you can also color the intermediate area in one color (say red) if AB. To do this, simply stack 3 areas:
    - curve of the min of A and B, with no fill
    - curve of the negative part of A-B (=- (A-B) if A- curve of the positive part of A-B (=A-B if A>B and 0 otherwise), in green
    52
    1. Pierrot33
       
      and if we want a logarithmic scale on the x-axis?
      1
    2. bibi
       
      It's perfect! Thank you very much!
      0
    3. didierj Posted messages 1 Status Member
       
      Hello,
      thank you for your help.
      I chose the option with 3 areas, since my curves intersect.
      However, at the intersection points, the areas are "overflowing" a bit. Do you have the same problem?
      0
    4. Mario
       
      You have been very helpful to me!
      Thank you!
      0