View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default change color to selected columns in a stacked column chart

Click once to select a series of columns, then click again to select just
one column, then format it like any other element (Format menu, double
click, or Ctrl+1).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Noa" wrote in message
...
Can I change colors to selected columns in a stacked column chart?
I have 3 data series for each year, and would like each group of 3 to be
colored differently.

The 'vary colors by point' option [under format data series/options] is
disabled for this type of chart.

Thanks,
Noa