VBA for Pivot Chart

Hi Everyone,

I have another problem with VBA and I want to say that I don't have wide experience in it.

Do you know how to check, for each series in the chart name of the X axis and Y axis ?

I can't find anything in the internet.

Thank you for help.

Blacky

Sorry I wasn't precise. As you can see on the pic below I have pivot chart with a pivot table. Below it is pic of pivot chart columns rows and Values.Pivot Chart_2.png

I know how to extract from the chart series name, which is FName + Values, e. g. Name1 Useful, Name1 Latest, Name2 Useful, ....

Do you know how can I extract in macro VBA only Name1, Name2,... which are values for FName in my example, so for columns.

I think that I need just only column value for specific series or something. Do you know the syntax for this in the VBA?

Thank you for interest.

Sorry I haven't see your replay.

I already solved my problem by using function InStr(1, MySeries.Name, "-") and than Left(MySeries.Name, InStr(1, MySeries.Name, "-") - 1).
with first function I am searching for position of character "-" - which is always appearing in MySeries.Name, then I am taking text from MySeries.Name up to position of character "-" minus 1.

It is not ideal but works