Get name of active series collection in active chart

[SteveWright]

Hi there,

I need to understand how I can return the series collection number from a chart.

e.g. I select activechart.seriescollection(1) in a workbook and I need to retrieve that 1 in code. This would enable me to format the selected pie piece.

Thanks in advance for your help,

Steve

 

[RoryA]

If you want to format the selected object, why not use Selection?

 

[SteveWright]

Thanks for the reply.

I'm not sure how to use that in my code. Could you write me a short line of example code that allows me to format the selected pie piece through vba?

Many thanks,

Steve

 

[RoryA]

If you have already selected one segment:

selection.Interior.Color = RGB(255, 0, 0)