View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Change gradient color in chart for Excel 2007

Hi,

After selecting gradient you need to change the 2 stop colours.
Select Stop1 and use the Color: dropdown to change the top half of column.
Select Stop2 and use the Color: dropdown to change the bottom half of the
column

For as single colour gradient you will need to set Stop2 to plotarea colour.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"NonTechie" wrote in message
...
I have Excel 2007. I want to have a gradient color for a chart. I go to
Format Chart Area and click Gradient fill and get a nice single color blue
gradient from light blue to white. I want to have a single color gradient
but
with a different color. The help menu talks about gradient stops, so I
tried
that, but when I use them with a different color, the blue is still on
part
of the chart. I really do not understand the gradient stop business. I
just
want to have a single color gradient with a color of my choice or a
two-color
gradient with two colors of my choice. I used to be able to do this with
ease
with Excel 2003, but can't figure out how to do it with Excel 2007. Any
help
would be most welcome.