how to rotate data labels in excel 2010

You can rotate a single data label by dragging it. You can also place data labels in a standard position relative to their data markers. Answered May, 06 2011

Use the following steps to add data labels to series in a chart:

1.

Click anywhere on the chart that you want to modify.
2.

On the Chart Tools Layout tab, click the Data Labels button in the Labels group.

A menu of data label placement options appears:
*

None: The default choice; it means you don't want to display data labels.
*

Center to position the data labels in the middle of each data point.
*

Inside End to position the data labels inside the end of each data point.
*

Inside Base to position the data labels inside the base of each data point.
*

Outside End to position the data labels outside the end of each data point.
3.

Select where you want the data label to be placed.

4.

On the Chart Tools Layout tab, click Data Labels→More Data Label Options.

The Format Data Labels dialog box appears. You can use the options on the Label Options, Number, Fill, Border Color, Border Styles, Shadow, Glow and Soft Edges, 3-D Format, and Alignment tabs to customize the appearance and position of the data labels.
5.

If you don't want the data label to be the series value, choose a different option from the Label Options area.

You can change the labels to show the Series Name, the Category Name, or the Value.
6.

Select Number in the left pane, and then choose a number style for the data labels.
7.

Customize any additional options and then click Close.

Read more: http://www.dummies.com/how-to/content/how-to-add-data-labels-to-an-excel-2010-chart.html#ixzz1LHlO0jAu Answered May, 03 2011

Yes,you can make it, but some complex. You can get tutorials in www.ehow.com/how_6364281_export-data-excel-make-labels.html in detail. Answered Dec, 31 2010

you canchange the position of a single data label by dragging it. You can also place data labels in a standard position relative to their data markers.

and On a chart , to reposition a specific data label, click that data label two times to select it. And then On the Layout tab, in the Labels group, click Data Labels, and then click the option that you want.
If you want to know more about it , you can access the web page:
http://office.microsoft.com/en-us/excel-help/add-or-remove-data-labels-in-a-chart-HP001234166.aspx
Good luck! Answered Apr, 21 2011