Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / December 2006

Tip: Looking for answers? Try searching our database.

Changing default chart settings like background colour etc

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
synthesizer_patel - 04 Dec 2006 14:07 GMT
Hi! new to the forum :-)

I do a lot of scientific graphs for presenting simple biological /
chemical data - the scientific standard for all data published in
journals is black lines and white background.

so when I have a presentation to do which requires around 15-30 charts
in it (not uncommon) - it should be a simple matter of changing the
default template to reflect this and then go ahead with my charts -
well you'd think so wouldn't you? - but can it be done ? - apparently
not.

even changing the chart colour options to black for all line/plot
colours to black - and all background colours to white - saving it then
restarting the PC didn't seem to have any effect

ps:

please don't send me to this thread:

http://www.excelbanter.com/showthread.php?t=31348

the poster was helpful - but seems to have misunderstood the question
that the guy asked- what the instuctions she gave do is change the
line/colour settings on a chart you have created BACK to the default
settings that are immutably set up within excel (i.e coloured scatter
lines and plot symbols, black gridlines, and grey background - the
exact opposite of what I need)

Signature

synthesizer_patel

Gord Dibben - 04 Dec 2006 18:11 GMT
Build one chart the way you like it.

Then Chart>Chart Type>Custom>User Defined>Add

You can set this as the Default Chart if you choose.

Gord Dibben  MS Excel MVP

>Hi! new to the forum :-)
>
[quoted text clipped - 24 lines]
>lines and plot symbols, black gridlines, and grey background - the
>exact opposite of what I need)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.