charts

[BillS]

is there a way to save a specific font in my chart templates...? everytime I pull up my template I have to change the font from 18 --> 11... i saved my template w the correct font but it still defaults to 18... pls advise...
thank you

 

[Luke M]

After you save the Chart as a Template, go to Chart Tools - Design - Type group, Change Chart Type. In the left menu, select Template, then select your saved template. Then, down at the bottom, click the "Set as Default Chart" button. Now, the next time you create a chart, it will select this chart first, and your font formats will be used.

 

[BillS]

seems to keep defaulting back to 13.2 font which is tolerable but font 11 should be do-able...

 

[Luke M]

Now I'm confused. I don't think font can be in a decimal number...

 

[BillS]

is it possible to write an if statement using name manager...? Exceptions being the name of an array... i.e.
=if(E12=Exceptions,H12,G12)

 

[Hui]

x.5 Font sizes are allowable
No other decimals are allowed
10.1 = 10
10.2 = 10
10.3 = 10.5
10.4 = 10.5
etc

 

[BillS]

sorry... changed subjects without changing subject line...
is it possible to write an if statement using name manager...? Exceptions being the name of an array... i.e.
=if(E12=Exceptions,H12,G12)

 

[Hui]

Yes

You can even use unmade named Formulas , of course you'll get an error until you make it

Hui...

ps: Please start your own posts

sorry... changed subjects without changing subject line...
is it possible to write an if statement using name manager...? Exceptions being the name of an array... i.e.
=if(E12=Exceptions,H12,G12)

 

[BillS]

i receive an error if written =if(E12=Exceptions,H12,G12)
to not receive an error, i have to use =IF(OR(E12=E5,E12=E6,E12=E7,E12=E8),G12,H12)
Exceptions is my name for the array E5:E8

 

[Somendra Misra]

@BillS

As @Hui suggested this seems to be a different problem, so create a new thread. Meantime you can try below formula also.

=IF(SUMPRODUCT(--(E12=$E$5:$E$8)),G12,H12)

Regards,

 

[Hui]

Bills

Try: =IFERROR(IF(INDEX(Exceptions,E4,0),H12),G12)

 

[BillS]

that worked... thx...
It let me change the array to my named array...

=IF(SUMPRODUCT(--(E12=Exceptions)),G12,H12)

will start new string next time...