How to Name Chart Objects
 

I have a spreadsheet that summarizes energy Key Indicators for all of
our companies US plants. There are approximately 150 individual charts
and I want to automate so they are dynamic.

Apparently I can't use named formulas to set my Y-Axis minimum or
maximum scales, nor the major or minor unit values. I can, however,
use the Worksheet_Activate event and set these values so they are also
dynamic.

My problem is that the graphs were created over time and as a result
the numbering is almost random.

Is there a utility available that will allow me to manually cycle and
set the individual chart object names to a meaningful (-to me-) naming
convention?

With some trial and error, I can probably create VBA code that will
cycle through all of the chart object on the active worksheet, create
an input box and assign the name. I was just hoping for a little bit
of a time saver...


--
DCSwearingen

Getting old, but love computers.
------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=565321

How to Name Chart Objects
 

http://peltiertech.com/Excel/ChartsH...ameAChart.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"DCSwearingen"
wrote in message
news:DCSwearingen.2bkith_1153943408.1831@excelforu m-nospam.com...

I have a spreadsheet that summarizes energy Key Indicators for all of
our companies US plants. There are approximately 150 individual charts
and I want to automate so they are dynamic.

Apparently I can't use named formulas to set my Y-Axis minimum or
maximum scales, nor the major or minor unit values. I can, however,
use the Worksheet_Activate event and set these values so they are also
dynamic.

My problem is that the graphs were created over time and as a result
the numbering is almost random.

Is there a utility available that will allow me to manually cycle and
set the individual chart object names to a meaningful (-to me-) naming
convention?

With some trial and error, I can probably create VBA code that will
cycle through all of the chart object on the active worksheet, create
an input box and assign the name. I was just hoping for a little bit
of a time saver...


--
DCSwearingen

Getting old, but love computers.
------------------------------------------------------------------------
DCSwearingen's Profile:
http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=565321

How to Name Chart Objects
 

That article helped tremendously...


--
DCSwearingen

Getting old, but love computers.
------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=565321