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