Modifying a Chart Object Name

P

pauloreiss

Im making a MACRO to alter montly many different files with the sam
paddern. In these files there are many sheets with a few Charts. Thos
charts are two for INCOME and two for PROFIT in each sheet. My proble
is that the name of the Charts in the macro appear with the number tha
Excel applyed to it and i would like to make standar names for eac
Chart. This way there would be only 4 chart names for each sheet
instead of 16 diferent chart names for the 4 sheets in the file i
working.
This is how the part of the macro looks:

ActiveSheet.ChartObjects("Gráfico 8").Activate
...

I would like to make "Gráfico 8" to be "Profit1"...

Anyone knows how to do this!???
Thanks..
 
P

pauloreiss

Plz people... I dont know where else to ask... In the HELP there wasnt
anything.
 
C

Cutter

There are plenty of hits for "Change chart name" in Google

Try this: (from Debra Dalgleish)
"Hold the Ctrl key, and click on the chart to select it
Click in the Name Box, to the left of the formula bar
Type a new name for the chart
Press the Enter key"
 
G

Guest

....within the visual basic editor (where you are looking at the code for your
macro) you should be able to just change the name. Highlight "Grafico1" and
type "profit1" in its place.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to change chart name only once 4
Sheet Names Randomly Change (Chart Sheets Only) 1
Macro to determine chart name 5
Changing Chart Parameters 7
Axes(xlCategory) for a chart-sheet in 2007 2
Changing chart name and sorting by chart name 1
Dynamic chart 1
Trying to make a line graph that encomposses many worksheets 1

Top