Excel Series Collection Name Property not working as expected

Hello all,

I've been experiencing weird results when trying to add a new chart series using VBA, and while referencing an Excel Table. Below is the portion of my code that I am using; note that the series is successfully added, and the XValue and Value properties reference the cells within the Excel Table correctly. However, the Name property hard codes the series input as text, not as a cell reference like the XValue and Value properties are stored.

Any tips on what could be causing the error is appreciated!

Please Login or Register  to view this content.

PS: The list columns are labeled correctly. My customer has the table formatted in a weird way and I'd rather not move fields around if possible.

Try this...

Please Login or Register  to view this content.

That did it! Can you explain why the .Address method was required?

Originally Posted by mcmahobt

That did it! Can you explain why the .Address method was required?

You're welcome.

The Name property is a string and will accept only text. It will evaluate a cell address in the form of "=SheetName!R1C1"

The Values and XValues properties are variants and will accept a Range or Array of values.

Clear enough, appreciate the help!