ExcelBanter - How to set the bar chart with different colour automatically

If you are using Excel 97 - 2003 and you often want to apply the same set of
colours, you can customize the bottom two rows of the palette. Tools,
Options, Color.

Fill colours in Series are automatically applied starting from the first
colour in row 6 of the palette. If you have more than 8 series the next fill
colours will be automatically applied from the 7th row. Note that the
palette is saved with the workbook. You might want to store your customized
palette in a template.

If you are using Excel 2007 you can change the "Theme" or make your own
customized colours. Series are formatted with each of the 6 accent colours
in turn, but with a different set of "TintAndShade" for each set of 6
series.

Alternatively, with all versions, you can format each series individually.

Regards,
Peter T

"lowbo" wrote in message
...
I would like to do the setting in Excel for a different colour in bar chart
with different data (or with formatting). How to do that ?