Chart names

[Richard Massey]

I am producing an Excel sheet with several pages of
identical looking charts sourcing different data sets.
6 charts to a page and 4 pages worth of charts.
I am using VBA to automatically change the scale of the
charts and want to automate it a bit more:

The VB code I want to use is similar to:

For Sheet_Num = 1 to 4
For Graph_Num = 1 to 6
Set myRange = Worksheets(Sheet_Num).Range(Graph_Num)
etc.
Next
Next

However, I currntly need to put a translation table in to
convert the Graph_Num into the actual graph name (Chart 1,
Chart 14, Chart 16, etc.)

I just want to rename the actual charts as 1, 2, 3, 4, 5
and 6.

Is this possible?

Rich

 

[Andy Pope]

Hi Richard,

To manually name the chart objects to something more useful for your
code do the following.
Select a chart with the mouse whilst holding the CTRL key. This will
then place the chartname in the Name box, next to the formula bar. Now
you give change the name and press enter.


Cheers
Andy