Hi,

I don't believe you can override the default position but you can change
the position of all the data labels in a selected series.

I created a Line chart and then selected the series. Using Chart Tools
Layout Labels Data Labels Above. This way can also be used on
existing data labels once select.

Or if the labels already exist select them and right click, chose Format
Data Labels. Pick Label Options from the list on the list of the dialog
and then Above from the Label Position options.

Cheers
Andy

Kermit wrote:
Is there a way to change the default position of a data label in an Excel 07
Chart from the right of the data point to above the data point? I have
looked through the data label options and excel options and found nothing. I
can only do it for each label individually through data label options, but it
will not change the default position. Any help would be appreciated.

--

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