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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
> news:[email protected]...
> >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?
>
>
>