exl 2007 macro label chart series with series name

[michelle_123]

Hi,

Does anyone have a macro that will label all the series in a pivot chart with the series name and I would like the label to be veritcal (rotate all text 270 degrees) and inside base.

I would really appreciate any help. I have searched all over for an answer!

thank you so much in advance.

excel 2007 pivot chart

 

[Derek Brown]

Hello and welcome to The Board.
The best place for Chart help and ideas is Jon Peltier's site:
http://peltiertech.com/Excel/Charts/ChartIndex.html

I don't know if it will work with a PIVOT chart but I have used the following idea on a normal chart:
http://peltiertech.com/WordPress/label-each-series-in-a-chart/
http://peltiertech.com/Excel/Charts/LabelLastPoint.html

Now they will label only the last data points but you may be able to adapt it for your requirements.