Duplicate chart names on multiple sheets

B

Breck

I have a workbook with multiple sheets. When I created the first sheet
I created 9 charts number "Chart 1" thru "Chart 9". After formating
these charts the way I wanted them I created multiple copies of
"Sheet 1" . Now all of the sheets have the same chart names "Chart 1"
thru "Chart 9". Will this cause a problem? I will be writing some VBA
code to manipulate these charts so I know that I will have to
specifically use the sheet that they are one in the code. I'm just
wondering if there are any other issues with having 15 "Chart 1"'s on
15 different sheets. Thanks for any response.
 
B

Bob Phillips

Breck,

I don't think there will be a problem, as long as you reference via the
sheet.

I have a number of applications that generate charts, and I always use the
same names on each sheet, and that has never been a source of problems to
me.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
B

Breck

Thanks for the response. I appreciate it

Bob Phillips said:
Breck,

I don't think there will be a problem, as long as you reference via the
sheet.

I have a number of applications that generate charts, and I always use the
same names on each sheet, and that has never been a source of problems to
me.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)
 

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

Top