| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
Yes. Just type in the name.
-- George Nicholson Remove 'Junk' from return address. "BJackson" wrote in message ... 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? |
|
#3
|
|||
|
|||
|
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" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
| Data range properties | Excel Discussion (Misc queries) | |||
| How can I check if data in external data range is changed after re | Excel Discussion (Misc queries) | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Hybrid Mode
