Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RedYellowGreen Color Banding in Chart Plot Area | Charts and Charting in Excel | |||
Changes to Plot area color | Charts and Charting in Excel | |||
Bubble Chart - Edit Color in plot area | Charts and Charting in Excel | |||
How do i change the default plot area backgroung color in excel? | Charts and Charting in Excel | |||
How do I change the excel chart default plot area color? | Charts and Charting in Excel |