D
DCSwearingen
I have a spreadsheet that summarizes energy Key Indicators for all o
our companies US plants. There are approximately 150 individual chart
and I want to automate so they are dynamic.
Apparently I can't use named formulas to set my Y-Axis minimum o
maximum scales, nor the major or minor unit values. I can, however
use the Worksheet_Activate event and set these values so they are als
dynamic.
My problem is that the graphs were created over time and as a resul
the numbering is almost random.
Is there a utility available that will allow me to manually cycle an
set the individual chart object names to a meaningful (-to me-) namin
convention?
With some trial and error, I can probably create VBA code that wil
cycle through all of the chart object on the active worksheet, creat
an input box and assign the name. I was just hoping for a little bi
of a time saver..
our companies US plants. There are approximately 150 individual chart
and I want to automate so they are dynamic.
Apparently I can't use named formulas to set my Y-Axis minimum o
maximum scales, nor the major or minor unit values. I can, however
use the Worksheet_Activate event and set these values so they are als
dynamic.
My problem is that the graphs were created over time and as a resul
the numbering is almost random.
Is there a utility available that will allow me to manually cycle an
set the individual chart object names to a meaningful (-to me-) namin
convention?
With some trial and error, I can probably create VBA code that wil
cycle through all of the chart object on the active worksheet, creat
an input box and assign the name. I was just hoping for a little bi
of a time saver..
