A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Changing *permanently* Excel's colors and graph fill for charting?



 
 
Thread Tools Display Modes
  #1  
Old February 24th, 2006, 04:34 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Changing *permanently* Excel's colors and graph fill for charting?

Is there a way of changing the default chart colors *permanently* so
that every *new* workbook has them?

I know about, but should not have to go through the manual nonsense
each time of copying the chart colors from another workbook. In other
words, I would like the color sequence for lines and fills to be part
of the normal Workbook template, so that charts automatically take on
my prefered colors. How can one do that?

Second, and this one truly bugs me, is that Excel fills in the
background of charts (the fill area) with dull grey. (What a
ridiculous choice on aesthetic grounds! What a bad user-interface
design that we seem stuck with it as the default for new workbooks!) I
would like to stop it from doing that and instead have each new chart,
in any new workibook, come up with the fill being white! Again, I
know about creating a chart and then making it the default for *that*
workbook, but I shouldn't need to do that each time for each new
workbook!

This is 2006, folks, and I cannot believe that Excel still cannot do
these things, still cannot save the user prefered colors and fills in
the basic template. I am hoping that I am simply wrong about all this
and that there's some obvious solution I've overlooked or have not
found on the net.

Even if Excel doesn't have a way of doing these things, perhaps there
is a way of hacking the default color and fill scheme. I know that
each upgrade of Word I run the Resource Editor and change the color of
the paragraph markers to red so that they will show up distinctly when
I reveal formatting marks.

  #2  
Old February 24th, 2006, 04:53 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Changing *permanently* Excel's colors and graph fill for charting?

Well, I figured out one thing-- I think!

I copied a small data set into a new workbook, created a graph, and
then changed the colors using Excel Preferences Chart Fills and Chart
Lines.

I then saved this as a template named "Workbook" in the Office Startup
Excel folder replacing the default workbook template.

Of course, that means every new document comes up with the small
dataset and chart. So I reopened the default Workbook and deleted the
data and the chart and re-saved it. Voila! It seems that I now have
chart colors and bar fills in the colors I'd prefer.

But that still doesn't get rid of the awful grey background. Note:
when one changes the Chart Fills colors that really is changing the bar
fills, not the actual background fill. (The Excel lingo should be
changed in that box.)

So, I've solved, I think, the colors problem... but how does one change
that ugly, dark, miserable grey fill?

  #3  
Old February 24th, 2006, 05:09 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Changing *permanently* Excel's colors and graph fill for charting?

Well, lo and behold, I repeated the same sequence, but this time also
changing the background fill to white, and saving that chart as a
custome user-defined chart and made it the default chart.

I then saved it as the default workbook. This part has been tricky as
when you change the type to Template, Excel jumps to the My Templates
folder, which isn't where you want to save this!

Instead you must navigate back to Office, Startup, Excel, and save the
template Workbook replacing the one that's there.

I then re-opened that template, deleted the data set and chart again,
and re-saved it.

So far, whenever I open a new workbook and create a graph, it has the
colors I chose and the background fill is white or None (whichever it
was that I selected!).

It should all be much easier-- one should be able to do all this within
the Excel preferences dialog box with a choice to save colors, bar
fills, and chart background fill as the default. But, at least, it can
be done!

Hope all this "ranting", rambling, and rummaging helps someone else!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Graph colors automatically change PuckMark Charts and Charting 1 October 21st, 2005 09:46 AM
Changing Default Colors in MS Graph [email protected] Powerpoint 1 February 4th, 2005 09:31 PM
Access/Microsoft Graph - Possible to control category colors via c Lawrence Mrazek Setting Up & Running Reports 2 December 8th, 2004 04:21 PM
Access/Microsoft Graph - Possible to control category colors via c Lawrence Mrazek Setting Up & Running Reports 0 November 29th, 2004 03:59 PM
Change default graph colors Jon Peltier Charts and Charting 0 February 6th, 2004 04:47 PM


All times are GMT +1. The time now is 03:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.