How to Name Chart Objects

**DCSwearingen** · 07-26-2006, 03:48 PM

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...

Jon Peltier · 07-27-2006, 10:30 PM

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

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

"DCSwearingen" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>