Range Name

queequeg · #1 (**permalink**) 04-05-04, 22:27

Hi gang!

I am new to the forum as well as to Excel. Please excuse me if you think that the question is too elementary!

Can range names be used when creating charts?

shades · #2 (**permalink**) 04-05-04, 22:42

Howdy! Welcome to the forum - and to Excel.

Yes, you can use range names. When you get to Data Source, click on the Series tab, and you can refer to the range that way. For more specialized charts, that is the best way to do it. I usually try to set up the chart with the actual references, then replace one named range at a time to make sure it is referencing properly.

queequeg · #3 (**permalink**) 04-05-04, 23:07

Wow! Thanks for the prompt reply and the warm welcome! Sure do appreciate it.

Quote:

Originally posted by shades
Howdy! Welcome to the forum - and to Excel.

Yes, you can use range names. When you get to Data Source, click on the Series tab, and you can refer to the range that way. For more specialized charts, that is the best way to do it. I usually try to set up the chart with the actual references, then replace one named range at a time to make sure it is referencing properly.

Internet Services

Web Development

Digital Marketing

Consumer Tech