Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trouble with Names on multiple sheets
I've created 2 sheets with data that have to be plotted on different
charts. I then created 1 sheet just for those charts to appear. On the first data sheet, I defined the Names, and when I looked at sheet 2, I could tell that the names were being taken on by Sheet 2. To plot the charts, I referred to the specific sheet and then the range name and I could tell that the different charts were referencing what I want to reference. The problem started when I created 2 more names later on. They did not take on to sheet 2! If I added the sheet name of Sheet 2 to the "definition", they will drop off any reference to sheet 1. I can't figure out why these were supposed to be global names but didn't work. Any clues? I'm about to pull my hair out... I was getting so close to having all my charts done. Thanks! A |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble with function for multiple data | Excel Worksheet Functions | |||
COUNTIF across multiple sheets with unknown names | Excel Worksheet Functions | |||
Duplicate chart names on multiple sheets | Charts and Charting in Excel | |||
Having trouble printing selected sheets in Excel | Excel Discussion (Misc queries) | |||
I am having trouble deleting sheets in Excel | Excel Worksheet Functions |