How to set all data labels with Series Name at once in an Excel 2010 chart

Question

I can't find how to set all data labels with Series Name at once. Do you know how? It's Excel 2010.

Do I really need to apply that format one series at a time? :(

The problem is *selection*, I can't select the labels from several series simultaneously.

I posed this question in Twitter first.

Thanks!

Answer 1

Hello,

chart series data labels are set one series at a time. If you don't want to do it manually, you can use VBA. Something along the lines of

Sub setDataLabels()

'

' sets data labels in all charts

'

Dim sr As Series

Dim cht As ChartObject

'

With ActiveSheet

    For Each cht In .ChartObjects

        For Each sr In cht.Chart.SeriesCollection

            sr.ApplyDataLabels

            With sr.DataLabels

                .ShowCategoryName = True

                .ShowValue = False

                .ShowSeriesName = True

            End With

        Next sr

    Next cht

End With

End Sub

Right-click the sheet tab, select View Code and paste the code into the code window. 

Set the desired True/False value for the three lines with the .Show[...] properties and hit F5 to run the macro on all charts in the sheet.

Answer 2

Have a look at this link, it should help you http://stackoverflow.com/questions/19725557/excel-chart-changing-all-data-labels-from-value-to-series-name-simultaneously