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

G

Guest

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?
 
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named-range source-data for pie charts on copied worksheets 4
Excel Can a pie of pie chart use animation/transitions? 1
Dynamic Bar of Pie Chart: Series1 Label & Value Issue 1
Creating Pie Chart 3
Pie Charts 1
pie chart areas reflect magnitude 5
Is it possible to put explanatory text at bottom of pie chart? 1
Pie charts 1

Top