View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TommoUK TommoUK is offline
external usenet poster
 
Posts: 4
Default Changing chart colours using VBA

Is it possible to change the colours of bars on a chart depending on the
value. For example, if a value is positive, colour the bar green, if
negative, colour it red. The 'invert if negative' check box within Excel sets
the bar to white if negative