Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Flow chart objects not visible in Excel spreadsheet. | Charts and Charting in Excel | |||
Copy Excel Chart (including drawn objects) into Word | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |