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

's Computer Specifications

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?

's Computer Specifications

Yes. Just type in the name.

--
George Nicholson

Remove 'Junk' from return address.

"BJackson" <(E-Mail Removed)> wrote in message
news:0DE9A0AD-C3BA-4242-B3BA-(E-Mail Removed)...
>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?

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
> news:0DE9A0AD-C3BA-4242-B3BA-(E-Mail Removed)...
> >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?
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using a named range as a data source for a chart	MichaelR	Microsoft Excel Charting	4	16th Jun 2008 04:15 AM
Using a named range as a data source for a chart	MichaelR	Microsoft Excel Worksheet Functions	0	15th Jun 2008 01:34 AM
Named range as chart data reference (error)	Keith R	Microsoft Excel Charting	8	13th Jun 2007 09:06 PM
Using a Named Range for Data Source In A Chart	=?Utf-8?B?Sm9lUA==?=	Microsoft Excel Charting	2	25th Apr 2007 02:33 AM
creating a filtered range/named range	mark kubicki	Microsoft Excel Programming	1	4th Nov 2006 03:14 PM