I would like to draw a bar chart with individual colours for each bar. The
option "vary colours by points" is shown in grey and cannot be seected.

You can format the bars individually. Select a single bar by single clicking
it to select the series, and single clicking it again to select just the
bar. Then double click to open the Format Point dialog, which will format
just this bar. With one bar selected, you can use the left and right arrow
keys to select a different bar.

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


"sparjolly" wrote in message
...
I would like to draw a bar chart with individual colours for each bar. The
option "vary colours by points" is shown in grey and cannot be seected.