Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default XL 07 - add color to specific part of plot area

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!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 71
Default XL 07 - add color to specific part of plot area

Jon Peltier has two solutions for you at his site:

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

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

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

"txgweedo" wrote in message
...
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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
RedYellowGreen Color Banding in Chart Plot Area DOUG ECKERT[_2_] Charts and Charting in Excel 8 September 8th 08 09:32 PM
Changes to Plot area color My Own IT dept Charts and Charting in Excel 3 August 28th 08 02:28 AM
Bubble Chart - Edit Color in plot area Scent Charts and Charting in Excel 2 May 10th 08 06:29 PM
How do i change the default plot area backgroung color in excel? Jared Charts and Charting in Excel 1 May 17th 06 11:26 AM
How do I change the excel chart default plot area color? gg96555 Charts and Charting in Excel 2 February 8th 05 08:36 PM


All times are GMT +1. The time now is 09:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"