Changing chart selection using macro

[zapp7]

If I use a macro to create 3 charts in Excel 2007, all of the chart names are "Chart 1". I'm trying to figure out how to easily distinguish between the 3 charts. I tried renaming the chart with:

Please Login or Register  to view this content.

but it tells me "the specified dimension is not valid for the current chart type."

Anyway, if someone could tell me a simple way to distinguish between different charts using code that would be great.

EDIT:

I discovered the issue. For whatever reason, charts must be named using:

Please Login or Register  to view this content.