AJP Excel Information

Changing name of embedded chart

You can manually change the name of a embedded chart via the Name box.

Although to get this to contain the charts name you have to select the chart as an object rather than have the chart selected. Hold the Shift key whilst selecting the chart.

Notice that the subtle different in selection is denoted by the colour of the selection handles. They are white instead of the normal black. The current chart name is now displayed in the Name box and can be edited.

The change can also be done via VBA code:

'rename selected chartobject
 ActiveChart.Parent.Name = "MyChartname"

Charting tip