data labels change format

's Computer Specifications

I have an Excel chart with data labels at the top of each series bar. The
label is foramtted in Arial font 10point and bold. When I update the data
and and refresh the chart, the data lables change to Times new Roman and 12
pt font. Is there a way to lock in the font format as a default?

Thanks

's Computer Specifications

Hi,

Any chance your chart is actual a pivot chart? If so check this KB article.
http://support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

john mcmichael wrote:
> I have an Excel chart with data labels at the top of each series bar. The
> label is foramtted in Arial font 10point and bold. When I update the data
> and and refresh the chart, the data lables change to Times new Roman and 12
> pt font. Is there a way to lock in the font format as a default?
>
> Thanks

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Format Data Labels	ela	Microsoft Excel Worksheet Functions	0	24th Apr 2010 03:20 PM
How select all data points/data labels at once (to format)?	kippers	Microsoft Excel Charting	2	1st Apr 2009 02:29 PM
Format Axis labels: change 20,000,000 to 20 MM	tkpmep@hotmail.com	Microsoft Excel Programming	2	10th Apr 2008 06:01 PM
Data labels; format data series; separator	kevin@modelfitness.com	Microsoft Powerpoint	2	7th Mar 2005 03:01 PM
How can I change the position/format for all data labels in a ser.	=?Utf-8?B?UGVhcmxCZWFzdA==?=	Microsoft Excel Charting	3	7th Dec 2004 08:07 PM