ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Defining default fonts for charts (https://www.excelbanter.com/charts-charting-excel/140576-defining-default-fonts-charts.html)

hmm

Defining default fonts for charts
 
I have been unable to make my chart settings "stick"; I want my x-y scatter
charts to have, for example, Arial 14 for title, Arial 11 for x an y axis
titles, and Times New Roman 10 for axis number scale. I want all fonts to be
non-scalable (by unchecking the appropriate box in the chart format box).

Instead, every time I create an x-y scatter chart, I get ALL titles' text to
be in Times New Roman, and scalable.

How do I make these settings? This is especially a question for titles,
since they don't even exist yet in the default template.

Barb Reinhardt

Defining default fonts for charts
 
The only thing I could suggest is to create some VBA code to set those values
you want and run it when you create a chart.


"hmm" wrote:

I have been unable to make my chart settings "stick"; I want my x-y scatter
charts to have, for example, Arial 14 for title, Arial 11 for x an y axis
titles, and Times New Roman 10 for axis number scale. I want all fonts to be
non-scalable (by unchecking the appropriate box in the chart format box).

Instead, every time I create an x-y scatter chart, I get ALL titles' text to
be in Times New Roman, and scalable.

How do I make these settings? This is especially a question for titles,
since they don't even exist yet in the default template.



All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com