Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
building chart from multiple sheets | Charts and Charting in Excel | |||
Can I duplicate headers and footers on multiple sheets? | Excel Worksheet Functions | |||
How do you delete duplicate addresses, but keep duplicate names? | Excel Discussion (Misc queries) | |||
Chart Covering Info from Multiple Sheets | Charts and Charting in Excel | |||
chart data from same cell on multiple sheets | Charts and Charting in Excel |