XL 07 - add color to specific part of plot area

Discussion in 'Microsoft Excel Charting' started by txgweedo, Jan 26, 2010.

  1. txgweedo

    txgweedo Guest

    I'm new to XL 07 and I'm trying to add color shading to a specific part of
    the plot area based on the y axis. I've tried adding a new series but XL
    says my line chart is too complex. I'm charting blood sugar levels taking at
    different times each day. I want to color the range from 80 to 120 as a
    'target level' across the chart. Please help if you can!
     
    txgweedo, Jan 26, 2010
    #1
    1. Advertisements

  2. Jon Peltier has two solutions for you at his site:

    http://peltiertech.com/Excel/Charts/BackgroundFill.html#XYArea2

    http://peltiertech.com/Excel/Charts/BackgroundFill.html#XYArea

    Robert Flanagan
    http://www.add-ins.com
    Productivity add-ins and downloadable books on VB macros for Excel

    "txgweedo" <> wrote in message
    news:...
    > I'm new to XL 07 and I'm trying to add color shading to a specific part of
    > the plot area based on the y axis. I've tried adding a new series but XL
    > says my line chart is too complex. I'm charting blood sugar levels taking
    > at
    > different times each day. I want to color the range from 80 to 120 as a
    > 'target level' across the chart. Please help if you can!
     
    Robert Flanagan, Jan 26, 2010
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest
    Replies:
    3
    Views:
    1,618
    Guest
    Nov 4, 2004
  2. Janwillem van Dijk

    Resize chart area without resizing plot area

    Janwillem van Dijk, Aug 1, 2005, in forum: Microsoft Excel Charting
    Replies:
    2
    Views:
    1,227
    Jon Peltier
    Aug 2, 2005
  3. Guest

    How to increase chart area without affecting plot area?

    Guest, Apr 20, 2006, in forum: Microsoft Excel Charting
    Replies:
    2
    Views:
    1,034
    Guest
    Apr 21, 2006
  4. Guest

    How do you show plot area only-no chart area

    Guest, Sep 19, 2007, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    384
    Del Cotter
    Sep 19, 2007
  5. Steve Vincent

    Repeating gradient for each vertical area of plot area

    Steve Vincent, Oct 23, 2009, in forum: Microsoft Excel Charting
    Replies:
    3
    Views:
    341
    Steve Vincent
    Oct 27, 2009
Loading...

Share This Page