+ Reply to Thread
Results 1 to 3 of 3

specifing colors in an excel chart

  1. #1
    keith
    Guest

    specifing colors in an excel chart

    I am creating excel charts to show temperatures that I have measured
    inside various types of buildings. I would like the graphs to show
    temperatures below twenty degrees C in one color, twenty to twenty six
    in a different color and above twenty six in another color.

    Thanks in advance for any help.
    Keith.

  2. #2
    Andy Pope
    Guest

    Re: specifing colors in an excel chart

    Hi,

    You can create conditional charts by using additional data series, one
    for each colour set. See these sites for further details.

    http://peltiertech.com/Excel/Charts/...nalChart1.html
    http://www.edferrero.com/charting.aspx

    Cheers
    Andy

    keith wrote:
    > I am creating excel charts to show temperatures that I have measured
    > inside various types of buildings. I would like the graphs to show
    > temperatures below twenty degrees C in one color, twenty to twenty six
    > in a different color and above twenty six in another color.
    >
    > Thanks in advance for any help.
    > Keith.


    --

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

  3. #3
    keith
    Guest

    Re: specifing colors in an excel chart

    On Tue, 23 May 2006 08:43:40 +0100, Andy Pope <andy@andypope.info>
    wrote:

    >Hi,
    >
    >You can create conditional charts by using additional data series, one
    >for each colour set. See these sites for further details.


    thanks again
    keith
    >
    >http://peltiertech.com/Excel/Charts/...nalChart1.html
    >http://www.edferrero.com/charting.aspx
    >
    >Cheers
    >Andy
    >
    >keith wrote:
    >> I am creating excel charts to show temperatures that I have measured
    >> inside various types of buildings. I would like the graphs to show
    >> temperatures below twenty degrees C in one color, twenty to twenty six
    >> in a different color and above twenty six in another color.
    >>
    >> Thanks in advance for any help.
    >> Keith.


+ 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