VBA - How to: ID a chart element by it's XValue (name)

[Chris The Rock]

This will be difficult to ask correctly, but I'll try.

I'm creating charts with code, adding one data series at a time. I've successfully done this.

In some of my charts, the data series include 13 points of data, made up of 12 months and YTD figures.

The request has come to me that the recipients want to see the YTD figures in the chart's Data Table, but not on the chart. I understand that normally this is not possible, but I've figured out a trick. I just need to remove the background and fill color for the YTD data point by setting it to "none".

Since I have to do this automatically, I need to program my code to find the YTD data point within the chart series. My problem is, I don't know which property of which object to reference to get the name of the data point. I know that the name "YTD" is the XValues range, but I can't seem to isolate it.

What I need to learn to do is search series for a "YTD" data point, and perform the desired actions if I find it.

Anyone out there know what I'm talking about?

Thanks in advance for any help.