View original (French)

Shade the area under a curve in Excel

funbreizhou Posted messages 89 Status Member -  
tontong Posted messages 2575 Registration date   Status Member Last intervention   -
Hello,

I would like to shade the area under a curve in Excel. The help offered on Google is not helpful, and the predefined functions do not suit my needs.
Does anyone have a simple idea?

Thank you!

Configuration: Windows XP / Internet Explorer 6.0

9 answers

  1.
    tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
     
    By setting the Ox axis in chronological order, the scale becomes proportional.

    A simple "Area" type graph may meet the need. Step by step:
    Select the values in a column --> simple "Area" graph (the one in the top left)
    Graph --> source data --> "series" tab, enter "axis labels" with the desired field.
    Graph --> Chart options --> "Axes" tab, check chronological.
    Select the Ox axis --> axis format --> "Number" tab, choose the Standard category.

    You can then refine the presentation through the "format" of various elements.
    1
  2. funbreizhou Posted messages 89 Status Member 11
     
    I used Excel 2003, the type of chart is a classic scatter plot.
    Sorry for the lack of information =]
    0
  3. tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
     
    If the request is simple, the solution is not obvious.
    If the data allows it, we can overlay an "area" chart with the X-axis in "chronological" and a scatter plot. Example:
    https://www.cjoint.com/?3GAluCyvbFT
    Come back to let us know if that suits you and your difficulties.
    0
  4. funbreizhou Posted messages 89 Status Member 11
     
    That's exactly what I want!
    I just have a problem: if I have, for example, on the x-axis (3, 7, 12), there will be a graphic unit between 3 and 7, and between 7 and 12. It's not proportional.

    I don't know if I'm being clear, but in any case, I can't adjust the scale.

    Thank you for your response!
    0
  6. revel
     
    You can view this course on plotting a graph with Excel; downloadable PDF course here: http://www.wupload.com/file/65485761/6050.zip
    0
  7. Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 491
     
    There are dozens of colors, textures, and images...
    ... but unfortunately for you, no hatching!

    In post #4, at 12:29, you exclaim "that's exactly what I want!" when it's not hatching that tontong suggested to you...
    Look for the mistake!

    Retirement is nice! Especially in the Caribbean... :-)
    Raymond
    0
  8. funbreizhou Posted messages 89 Status Member 11
     
    Hatching or filling, it doesn't matter! Please forgive this imprecision...
    In any case, tontong's proposal suited me perfectly!

    I can't seem to solve this scale problem, oh well, I’ll manage another way.

    Thank you for your help and have a great day!
    0
  9. tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
     
    Hello,
    In a small example, try to follow the detailed procedure in message #5.
    I am not at home at the moment and I only have Xl2007. The screenshots I could take wouldn't help you.
    Sorry for not being able to do better.
    0
  10. tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
     
    Hello,
    If we knew what type of chart you created and which version of Excel, a response would be feasible ;-)
    -1