View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Jennie Wren
 
Posts: n/a
Default How do I have one gridline in chart a different colour

I want to show the minium and maximum temp lines on a chart to show when the
temps have gone over or under - clearly. How can I change ONE gridline to
another colour/style?

Also in the spreadsheet I would like a similar thing. Every time I place a
number in that is over or under certain amounts - I would want that figure to
automatcially show in a colours or flash etc.