I need to create a BLANK chart using VBA and rename it.
I am using Charts.Add

The problem i keep running into is that when i create a new chart, it
increments chart1 then chart2, etc... even if i rename the new chart

I am creating a module to be used in MSAccess to automate excel, so i will
not have the luxury of knowing what the new chart name will be.

It would be great if i could do something like

VariableNewChartName = Charts.Add
Sheets(VariableNewChartName ).Name = VariableMyNewName



or something like that