View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
wgnewman wgnewman is offline
external usenet poster
 
Posts: 6
Default Color change on bars when goal met

How do you have a bar change/begin a new color when the total reaches and
surpasses a goal/target? For example, if a series has totals above and below
a goal of, say, 70, I want each bar to show when that goal is met and to have
a different color on the same said bars displaying the amount above the goal.