How to customise colour schemes for Excel 2003

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I have been using Excell for some time and get annoyed by the boring colour
schemems when doing charts and graphs, I have been changing manulally each
time. Is there any cheap way of customising the colour schemes?
 
Jason

Tools>options>Color>Modify

In xl2k You can replace any color with the new one you like but you are
limited to
the 40 that are allowed in the pallet.

Mike Rogers
 
Thanks Mike,
I continued to search Web after posting and found much better result by
using american spelling ie 'Color' & 'Customizing'

Jason
 
There are really 56 colors in the palette, though not all are always
displayed. You can use the last two rows through the Format <object> dialog.
All 56 are available when formatting charts and shapes.

In the Tools menu > Options > Color tab, you will notice that the bottom two
rows are labeled Chart Fills and Chart Lines. These are the automatic colors
Excel uses when formatting a chart, where the first series is formatted with
the first color in the row, etc.

Here's a tutorial on the Excel color palette:
http://www.exceluser.com/explore/anycolor.htm

- Jon
 
Back
Top