I would like to create a Defined Name range to use as a the value for a
series in a chart.

Example: Cell B2 equals January Sales; Cell C2 equals February sales; and
cell D2 equals March sales. So, B2:D2 equals sales for Jan, Feb, and Mar. I
can name that range of cells (B2:D2) "Sales".

I would like to have a series in a chart named "Sales". Now, for the Values
of that series, I could put B2:D2. However, I would like to put the Defined
Name "Sales" instead. That way, if I have 5 different charts that graph
monthly sales (B2:D2), to add April sales to the charts, I don't have to go
to each chart and update the Values range to be B2:E2, I could just update my
Defined Name of "Sales" to now be B2:E2, and all of the charts should update
automatically.