Area Chart Data Label

[djt76010]

I have a 100% Stacked Area Chart in Excel and I would like to label each area instead of using a legend. When I turn on the Data Labels it defaults to show the values and when I go to "More Data Label Options..." and select "Series Name" it only applies to one Series at a time. I would also like to format the Data Labels but it is making me do that one at a time. Is there a way to make changes to "More Data Label Options..." apply to all of the Data Labels?

 

[sdruley]

03.21.2013-23.15.55 - sdruley's library

Just a couple of ideas to consider