+ Reply to Thread
Results 1 to 3 of 3

Different background color depending on x-axis value

  1. #1
    Registered User
    Join Date
    08-03-2006
    Posts
    5

    Different background color depending on x-axis value

    Hi!

    Is there any way to have the background in a chart have different colors depending on x-axis values?

    Like
    x-axis value 1-10 => blue background
    x-axis value 10-20 => red background

    Thanks

  2. #2
    Jon Peltier
    Guest

    Re: Different background color depending on x-axis value

    Here are a few of the ways you can get custom background fills for your
    charts"

    http://PeltierTech.com/Excel/Charts/...tml#Background

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Tutorials and Custom Solutions
    http://PeltierTech.com
    _______


    "RealRaven" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Hi!
    >
    > Is there any way to have the background in a chart have different
    > colors depending on x-axis values?
    >
    > Like
    > x-axis value 1-10 => blue background
    > x-axis value 10-20 => red background
    >
    > Thanks
    >
    >
    > --
    > RealRaven




  3. #3
    Registered User
    Join Date
    08-03-2006
    Posts
    5

    Amazing

    Amazing, it looks really great. Weird that I have to fool excel into doing this, feels like something they (m$) would like us to be able to do

    Thanks.

+ 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