Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default Changing default chart settings like background colour etc

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)
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 22,906
Default Changing default chart settings like background colour etc

Build one chart the way you like it.

Then ChartChart TypeCustomUser DefinedAdd

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


Gord Dibben MS Excel MVP

On Mon, 4 Dec 2006 14:07:01 +0000, synthesizer_patel
wrote:


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)


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing Default paper size vIQleS Setting up and Configuration of Excel 4 February 15th 06 12:35 AM
Is it possible the change the default chart formatting. Kingston999 Charts and Charting in Excel 1 January 7th 06 02:19 AM
Pivot Chart - default chart type Rav99 Excel Discussion (Misc queries) 4 September 6th 05 01:20 AM
Changing the default settings on the comment box JEN Excel Discussion (Misc queries) 1 June 2nd 05 08:57 PM
Changing chart orientation Melissa Charts and Charting in Excel 3 December 10th 04 10:15 PM


All times are GMT +1. The time now is 10:04 AM.

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

About Us

"It's about Microsoft Excel"