Can I use named range in data range box when creating pie chart?

I have 75 pie charts to create today. Is there a way to use named ranges in
the data range box to speed this up?

Yes. Just type in the name.

--
George Nicholson

Remove 'Junk' from return address.


"BJackson" <BJackson@discussions.microsoft.com> wrote in message
news:0DE9A0AD-C3BA-4242-B3BA-3CC3F0D87894@microsoft.com...
>I have 75 pie charts to create today. Is there a way to use named ranges
>in
> the data range box to speed this up?

Thank you! I was making it too difficult, thinking I needed to include the
Sheet name along with the name range. That worked beautifully and will save
me a couple hours of work!

"George Nicholson" wrote:

> Yes. Just type in the name.
>
> --
> George Nicholson
>
> Remove 'Junk' from return address.
>
>
> "BJackson" <BJackson@discussions.microsoft.com> wrote in message
> news:0DE9A0AD-C3BA-4242-B3BA-3CC3F0D87894@microsoft.com...
> >I have 75 pie charts to create today. Is there a way to use named ranges
> >in
> > the data range box to speed this up?
>
>
>