Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Shading in line graphs

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is it possible to shade the area between two lines in a line graph.
    At present I am cutting and pasting into a drawing programme and hand drawing a shape to shade - very time consuming and a mare if any data points change

    Please help!

  2. #2
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,919
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-12 04:44, Sarah Cadden wrote:
    Is it possible to shade the area between two lines in a line graph.
    At present I am cutting and pasting into a drawing programme and hand drawing a shape to shade - very time consuming and a mare if any data points change

    Please help!
    One possibility is to use "Area" type of chart, which will paint the area between two lines. You can then adjust the colors as you wish.
    Eli

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Eli thanks for responding
    the trouble I have with area graphs is that it adds the values of the two lines together

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    yeah, what you could do is create new values to do the equivilent area graph.

    lets say your values are in columns A and B.

    so you start new columns C and D. In column C you use the formula to give the minimum of the two values...

    eg. in cell C2...
    =MIN(A2:B2)

    ...then in column D you do the difference between the two values that must be added on...

    eg. in cell D2...
    =MAX(A2:B2)-C2

    ...then chart C & D instead of A & B. then play with the shading so that there is only shading between the two lines and bob's you uncle.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •