View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] p.strijbosch@chello.nl is offline
external usenet poster
 
Posts: 3
Default Advanced chart question

Hi,

I have an interesting question on charting, hope someone can help me
out with it. For a performance analysis I am showing both the
performance of a portfolio (line) and its corresponding benchmark
(bar). In order to make the out- or under performance more visible I
would like to give to "balls" in the line a red color in case of
under
performance and a green color in case of out performance. Obviously
you can do this manual but I have over twenty graphs with 20 points;-
(...........
Any suggestions if this can be set automatic??


many thanks!


Rgds
Robert