How to set the bar chart with different colour automatically

L

lowbo

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 ?
 
P

Peter T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot charts formatting 1
Can't format 'invert if negative' colour programmitically (macroignores it!) 0
How to create a bubble chart with more than 2 variables 0
How do Bar chart where Bar colour changes with different data Valu 1
Convert Error Bars to Series and Colour 1
Formatting a bar chart 1
Gantt chart colour change 4
How to set the bar with same X-axis value in same colour? 1

Top