Always use specific RGB colors in Excel Chart 1

[Welshbird]

Hi Chaps,

I've changed the chart line colors in my Excel 2003 workbook (via tools, options, color) and set the chart lines to be the RGB colors from my company logo.

Is there a way for that to happen in all spreadsheets? It only saves that for the spreadsheet I was using at the time, and I suspect I will always want to use these colors.

Thanks guys.

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[GlennUK]

If you want those colours available in another book then you could import them, when they are required. Make sure that your changed book is also open, and in your new chart book do Tools/Options/Colors, and use the drop-down labelled Copy Colors From to choose the book where the colors already exist.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Welshbird]

Thanks Glenn! I guess I should just save a CorpColor.xls somewhere then...



Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[GlennUK]

You could have it as a hidden workbook in your startup folder. ( to save a workbook as hidden, make any trivial change to the workbook, just so that Excel marks it as changed, and do Window Hide, and then do Shift/File/Close All, and you should get a prompt to say "Do you want to save xxx" etc etc .... by the way Close All only appears under the File menu when Shift is pressed ).

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Welshbird]

That sounds like a superb solution! I'll do that. Cheers Glenn.

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[Welshbird]

OK - Have done that, but now when I start up my machine so does an empty incidence of Excel. Any cunning ideas as to stopping that happening?

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[SkipVought]

Use a TEMPLATE, that has all the things your need in a new workbook.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Welshbird]

Skip - At the risk of asking a daft question - If I do that can I bung a switch or something so that when I open Excel I always get that? Would that still work if I'm opening a spreadsheet sent to me from someone else?

(YOu can tell I'm new in this office - trying to be untra efficient. Don't worry, it probably won't last for ever...)

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[GlennUK]

OK - Have done that, but now when I start up my machine so does an empty incidence of Excel. Any cunning ideas as to stopping that happening?

... er, I don't know what you did, but I'd guess that it wasn't just putting CorpColor.xls in the Excel Start Up folder. Did you put something in the Windows Start Up area????

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Welshbird]

Oh! Ha. I is a blonde day today...

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[Welshbird]

Ah. Security is such that I can't save something to my Excel startup folder here.

Oh well, have to have another plan. Any other ideas guys?

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[GlennUK]

Can you generate a Personal.xls? That is, can you record a macro, that stores itself in Personal Macro Workbook ( it's an option in the drop-down for location to Store Macro In, when you do menu command Tools/Macro/Record New Macro )?

If so, then unhide your Personal.xls and store your colors there, and rehide.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Welshbird]

Ah - excellent idea - I'll try that. Thanks for all help guys.

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen