+ Reply to Thread
Results 1 to 4 of 4

How to vary color in an area chart between negative or positive d.

  1. #1
    Gulf Stream
    Guest

    How to vary color in an area chart between negative or positive d.

    How can I vary the color in an area chart between positive and negative data
    points. Using zero as the defining level, anything greater than zero have
    one color and anything less than zero having a different color. Thank you
    for your help.

  2. #2
    John Mansfield
    Guest

    RE: How to vary color in an area chart between negative or positive d.

    Gulf Stream,

    Set up two series – one for positive values and one for negative values.
    Add a one-row space between any data point that crosses zero. For example,
    assume your original data is in a single column starting in cell A2. The
    data looks like this:

    a 2
    b 4
    c -4
    d -3
    e 6
    f -3
    g 5
    h 7

    Rearrange it to look like this (the title "Positive" is in cell A2 - the
    entire range now covers A1 to B13:

    Positive Negative
    a 2 0
    b 4 0

    c 0 -4
    d 0 -3

    e 6 0

    f 0 -3

    g 5 0
    h 7 0

    Note the row-space between any row where the values go from positive to
    negative or negative to positive. Create the area chart based on the revised
    setup.

    ----
    Regards,
    John Mansfield
    http://www.pdbook.com



    "Gulf Stream" wrote:

    > How can I vary the color in an area chart between positive and negative data
    > points. Using zero as the defining level, anything greater than zero have
    > one color and anything less than zero having a different color. Thank you
    > for your help.


  3. #3
    John Mansfield
    Guest

    RE: How to vary color in an area chart between negative or positiv

    Gulf Stream,

    I apologize - I missed something in my example which is causing the chart to
    be inaccurate. The X axis values are not consistently spaced in the setup
    that I described. I'll continue to work on it.

    John Mansfield

    "John Mansfield" wrote:

    > Gulf Stream,
    >
    > Set up two series – one for positive values and one for negative values.
    > Add a one-row space between any data point that crosses zero. For example,
    > assume your original data is in a single column starting in cell A2. The
    > data looks like this:
    >
    > a 2
    > b 4
    > c -4
    > d -3
    > e 6
    > f -3
    > g 5
    > h 7
    >
    > Rearrange it to look like this (the title "Positive" is in cell A2 - the
    > entire range now covers A1 to B13:
    >
    > Positive Negative
    > a 2 0
    > b 4 0
    >
    > c 0 -4
    > d 0 -3
    >
    > e 6 0
    >
    > f 0 -3
    >
    > g 5 0
    > h 7 0
    >
    > Note the row-space between any row where the values go from positive to
    > negative or negative to positive. Create the area chart based on the revised
    > setup.
    >
    > ----
    > Regards,
    > John Mansfield
    > http://www.pdbook.com
    >
    >
    >
    > "Gulf Stream" wrote:
    >
    > > How can I vary the color in an area chart between positive and negative data
    > > points. Using zero as the defining level, anything greater than zero have
    > > one color and anything less than zero having a different color. Thank you
    > > for your help.


  4. #4
    Andy Pope
    Guest

    Re: How to vary color in an area chart between negative or positived.

    Hi,

    I have created an example.
    http://www.andypope.info/ngs/ng33.htm

    There's not much in the way of explanation I'm afraid.

    The formula are standard trig calcs in order to determine x and y values
    for the 2nd data series.

    The secondary x axis is changed to a data axis. Use right click, chart
    options to get the secondary x axis displayed so you can format it.

    Cheers
    Andy

    Gulf Stream wrote:
    > How can I vary the color in an area chart between positive and negative data
    > points. Using zero as the defining level, anything greater than zero have
    > one color and anything less than zero having a different color. Thank you
    > for your help.


    --

    Andy Pope, Microsoft MVP - Excel
    http://www.andypope.info

+ 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