Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 54
Default Duplicate chart names on multiple sheets

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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 10,593
Default Duplicate chart names on multiple sheets

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)

"Breck" wrote in message
...
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.



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 54
Default Duplicate chart names on multiple sheets

Thanks for the response. I appreciate it

"Bob Phillips" wrote in message
...
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)

"Breck" wrote in message
...
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
building chart from multiple sheets Brad K. Charts and Charting in Excel 1 October 26th 07 02:04 PM
Can I duplicate headers and footers on multiple sheets? HeatherDBecerra Excel Worksheet Functions 2 April 13th 07 09:12 PM
How do you delete duplicate addresses, but keep duplicate names? Shelly Excel Discussion (Misc queries) 1 August 28th 06 10:36 PM
Chart Covering Info from Multiple Sheets OlYeller21 Charts and Charting in Excel 1 July 22nd 06 02:42 AM
chart data from same cell on multiple sheets drhamann Charts and Charting in Excel 2 April 15th 05 12:53 AM


All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"