Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Cell A82 can be one of two values; either zero(0) or one(1). And changes
from one day to the next because it's derived from several other cells that change daily. I have four line charts on four sheets based on data in the one numbers sheet. These were manually colored with white chart areas. And white plot areas. Is there a macro available that would color the four chart areas only yellow if cell A82 is one and color white chart areas if cell A82 is zero? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Resize chart area without resizing plot area | Charts and Charting in Excel | |||
Resize chart area without resizing plot area | Excel Programming | |||
How to Dynamically Set Print Area | Excel Discussion (Misc queries) | |||
Dynamically setting Print Area | Excel Programming | |||
Excel 2000 Dynamically Set Print Area | Excel Programming |