ExcelBanter - Chart name in Named box

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Chart name in Named box (https://www.excelbanter.com/charts-charting-excel/97086-chart-name-named-box.html)

Hari

Chart name in Named box

Hi,

If I click on a chart, then the named box either shows chart area or
plot area (or value axis etc). But I want to know the name of the chart
itself.

I have tried clicking on the border of the chart, but not able to get
the name displayed.

Im using an efficient way ( MsgBox ActiveChart.Name ) to know the name
of the chart.

Can somebody please guide me.

Regards,
HP
India

Hari

Chart name in Named box

Oops, I didnt see the post just before mine.

Shift key did it.

Thanks Andy,

Regards,
HP
India

Hari wrote:
Hi,

If I click on a chart, then the named box either shows chart area or
plot area (or value axis etc). But I want to know the name of the chart
itself.

I have tried clicking on the border of the chart, but not able to get
the name displayed.

Im using an efficient way ( MsgBox ActiveChart.Name ) to know the name
of the chart.

Can somebody please guide me.

Regards,
HP
India

All times are GMT +1. The time now is 09:47 PM.