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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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) -- synthesizer_patel |
#2
|
|||
|
|||
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) |
Thread Tools | |
Display Modes | |
|
|