View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
silver23 silver23 is offline
external usenet poster
 
Posts: 16
Default Coloring Chart Area Dynamically?

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?