Chart Series Names in VBA

[tess333]

Hi,
I need to combine two names, range Y1 and Y2 to be the series name in a chart. The code works for Y1 and Y2 separately, but not for the combined version. The bug is the objSeries.Name line. The names are defined as ranges. The cells are merged cells, but the addressing is correct. Below some lines of the VBA code:

Please Login or Register  to view this content.

I'd appreciate the help! Thank you

[Andy Pope]

If you try to do this manually you will see the error.

The name must be either a single cell, row or column.

Your range is multiple rows and columns.