Changing Chart Name

[kpark91]

Hello,

I've recorded a macro that deals with scatter plot graph.

    Sheet1.ChartObjects("Chart 1").Activate
    With ActiveChart.SeriesCollection(1)
        .Name = "=""Data"""
        .XValues = "=a.xlsm'!scatterX"
        .Values = "=a.xlsm'!scatterY"
    End With

This macro simply changes the name of the series and data range to plot.

However, my question is:
How do I view the chart property which states its name (like "Chart 1")?
Moreover, is it possible for me to change the names?

Thank you very much in advance,
kpark

 

[VoG]

Try like this

ActiveSheet.ChartObjects("Chart 1").Name = "VoG"

you can also use the Name property to read the name.

 

[njimack]

ActiveChart.Parent.Name = "Chart 1"

 

[kpark91]

Hello, VoG and njimack.

I haven't tried njimack's code yet but I know VoG's code works great.
Thanks alot.

But one of my questions was not answered or probably misunderstood.
So, here is my situation.

I have many different types of charts and I am in the process of automating them so that the graphs can be updated from time to time.
However, in order to update them I need to know the graphs' names.
Right now, I am recording macro to find out the charts' names one by one to get the name of "Chart 1" as the code shown above.

Are there any ways I can get the names of the charts without recording the macro?
For example, right-clicking on the chart and then clicking the property?? (something as easy as this?)

Thank you alot again
kpark

 

[VoG]

In Excel 2010 (and I think XL 2007) the chart's name shows up in the Name box if you click on the chart.

In earlier versions display the drawing toolbar (View, Toolbars if in Excel 97-2003). Then select the select objects tool by clicking on the button that looks like an arrow head. When you click on an embedded chart with this tool, you can then click in the name box and change the name of the chart.

 

[kpark91]

Hi, VoG.

I have found the name box and verified the name.

I really appreciate your help! Thank you alot.

For other viewers,
in XL2007, name can be found in Chart Tools > LayOut > Properties section (in the ribbon). The name should be there all the way at the right

Thanks alot!

 

[gboe1964]

Look at this link. There is much useful information here.

http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html#topofpage