Hi there!

Does anyone have a "nice looking" color palette that they'd be willing
to share.

The Standard palette is pretty downright ugly. Somebody must have come
up with a palette that makes charts look more appealing....right?? :-)

Thanks!--Jason

Jason

"Nice looking" to me may be downright ugly to me.

Suggest you roll your own.

ToolsOptionsColor.

Under Chart Fills and Chart Lines make the modifications you wish.

Note: this is a workbook setting but you can import this color scheme into any
other open workbook.

OR create a template with your modified colors and have it as the default
FileNew workbook.

Open a new workbook. Customize the colors as you wish. FileSave
As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook
"BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for FileNew or the Toolbar button FileNew

Do not use FileNew...Blank Workbook or you will get the Excel default workbook.

Existing workbooks are not affected by these settings.


Gord Dibben MS Excel MVP

On 5 Sep 2006 13:05:01 -0700, "Jason" wrote:

Hi there!

Does anyone have a "nice looking" color palette that they'd be willing
to share.

The Standard palette is pretty downright ugly. Somebody must have come
up with a palette that makes charts look more appealing....right?? :-)

Thanks!--Jason

"Nice looking" to me may be downright ugly to me.

Should read "Nice looking" to me may be downright ugly to you..


Gord


Gord Dibben MS Excel MVP

Hi Gord,

Yeah...you're right...beauty is most certainly in the eye of the
beholder. I guess I was just hoping that someone would have a color
layout that they were "proud" of, and wanted to share. Going through
color-by-color in the ToolsOptionsColor dialog is quite tedious, and
I just don't have the patience. :-)

Thanks for the technical info on setting up the standard template.

Bye!--J



Gord Dibben wrote:
Jason

"Nice looking" to me may be downright ugly to me.

Suggest you roll your own.

ToolsOptionsColor.

Under Chart Fills and Chart Lines make the modifications you wish.

Note: this is a workbook setting but you can import this color scheme into any
other open workbook.

OR create a template with your modified colors and have it as the default
FileNew workbook.

Open a new workbook. Customize the colors as you wish. FileSave
As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook
"BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for FileNew or the Toolbar button FileNew

Do not use FileNew...Blank Workbook or you will get the Excel default workbook.

Existing workbooks are not affected by these settings.


Gord Dibben MS Excel MVP

On 5 Sep 2006 13:05:01 -0700, "Jason" wrote:

Hi there!

Does anyone have a "nice looking" color palette that they'd be willing
to share.

The Standard palette is pretty downright ugly. Somebody must have come
up with a palette that makes charts look more appealing....right?? :-)

Thanks!--Jason

This might give you some ideas on how to save your self some time
playing with colours.
http://www.blog.methodsinexcel.co.uk...colour-pallet/

Cheers
Andy

Jason wrote:
Hi Gord,

Yeah...you're right...beauty is most certainly in the eye of the
beholder. I guess I was just hoping that someone would have a color
layout that they were "proud" of, and wanted to share. Going through
color-by-color in the ToolsOptionsColor dialog is quite tedious, and
I just don't have the patience. :-)

Thanks for the technical info on setting up the standard template.

Bye!--J



Gord Dibben wrote:

Jason

"Nice looking" to me may be downright ugly to me.

Suggest you roll your own.

ToolsOptionsColor.

Under Chart Fills and Chart Lines make the modifications you wish.

Note: this is a workbook setting but you can import this color scheme into any
other open workbook.

OR create a template with your modified colors and have it as the default
FileNew workbook.

Open a new workbook. Customize the colors as you wish. FileSave
As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook
"BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for FileNew or the Toolbar button FileNew

Do not use FileNew...Blank Workbook or you will get the Excel default workbook.

Existing workbooks are not affected by these settings.


Gord Dibben MS Excel MVP

On 5 Sep 2006 13:05:01 -0700, "Jason" wrote:


Hi there!

Does anyone have a "nice looking" color palette that they'd be willing
to share.

The Standard palette is pretty downright ugly. Somebody must have come
up with a palette that makes charts look more appealing....right?? :-)

Thanks!--Jason



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

I was just browsing and noticed your question. Be careful on you use of
this. Colors stay with the PC user's option setup. The pallet consists of 64?
colors. Which can be custom selected for your purposes, fine. HOWEVER, if you
take that same file and give it to 'Jim', his color pallet will not match
yours and the results could be ugly. Try coding the color of the line using
RGB values. It depends on the distribution of the report. you may also play
with paterns in your graph column format.

Candyman

"Andy Pope" wrote:

This might give you some ideas on how to save your self some time
playing with colours.
http://www.blog.methodsinexcel.co.uk...colour-pallet/

Cheers
Andy

Jason wrote:
Hi Gord,

Yeah...you're right...beauty is most certainly in the eye of the
beholder. I guess I was just hoping that someone would have a color
layout that they were "proud" of, and wanted to share. Going through
color-by-color in the ToolsOptionsColor dialog is quite tedious, and
I just don't have the patience. :-)

Thanks for the technical info on setting up the standard template.

Bye!--J



Gord Dibben wrote:

Jason

"Nice looking" to me may be downright ugly to me.

Suggest you roll your own.

ToolsOptionsColor.

Under Chart Fills and Chart Lines make the modifications you wish.

Note: this is a workbook setting but you can import this color scheme into any
other open workbook.

OR create a template with your modified colors and have it as the default
FileNew workbook.

Open a new workbook. Customize the colors as you wish. FileSave
As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook
"BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for FileNew or the Toolbar button FileNew

Do not use FileNew...Blank Workbook or you will get the Excel default workbook.

Existing workbooks are not affected by these settings.


Gord Dibben MS Excel MVP

On 5 Sep 2006 13:05:01 -0700, "Jason" wrote:


Hi there!

Does anyone have a "nice looking" color palette that they'd be willing
to share.

The Standard palette is pretty downright ugly. Somebody must have come
up with a palette that makes charts look more appealing....right?? :-)

Thanks!--Jason



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info