View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Alex
 
Posts: n/a
Default Help with an Area chart

I have the following series and values:

series actual value 92.95%
series normal value 98.00%
series stretch value 99.00%
series break value 100.00%

I need an area chart, which I have, but the series are shaded as follows:
the Acutal series is shaded from 86% (chart minimum) to 92.95% and the Normal
series is shaded from 92.95% to 98.00%, etc. . . Is there a way that my chart
can shade the Actual series from 92.95% to 98.00% and the Normal series from
98.00% to 99.00% and so on? Thanks so much -