Not the answer you're waiting for, but it's better not to use gradients at
all. They can obscure the information in the chart and lead to
misinterpretation.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Scott" wrote in message
...
I am using Excell 2007. Whenever I want to add a gradient to a color - for
example in a bar or pie chart - it shows me the types of gradients in a
stupid light blue color. If I choose one it changes my color in the chart
to
this color and does not apply the gradient to the color I already have in
place. How can I change this default behavior?