Using Defined Names in Charts

  • Thread starter Thread starter bobburg
  • Start date Start date
B

bobburg

I am using Office 2002.
I am trying to create a chart that has only one Series called Data. The
values for DATA is a name called SCROLL_DATA. The name has been defined
using the Insert-Name-Define action. The workbook is called Quality
Escapes.xls I have entered the following in the values box as I have
seen many instruction as follows

=Quality Escapes.xls!SCROLL_DATA

What am I doing wrong.
 
notice the ' placement or use no space in the name

=Quality Escapes.xls!SCROLL_DATA
='Quality Escapes.xls'!SCROLL_DATA
 

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

Using Defined Names in a Chart 2
Using a named range in a chart 4
How to duplicate a chart that relies on dynamic named ranges 2
problem with an Excel chart 1
Dynamic charts with named range Windows 8.1 3
Stacked Bar Chart 1
Disappearing chart legend 2
Chart with Named Range error 1

Back
Top