Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using Defined Names in a Chart
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. -- bobburg ------------------------------------------------------------------------ bobburg's Profile: http://www.excelforum.com/member.php...o&userid=22006 View this thread: http://www.excelforum.com/showthread...hreadid=466641 |
#2
|
|||
|
|||
Hi
Instead of workbook name, use sheet name, which contains your data - excel replaces it with workbook name automatically. I.e. you enter the reference as =SheetName!RangeName Arvi Laanemets "bobburg" wrote in message ... 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. -- bobburg ------------------------------------------------------------------------ bobburg's Profile: http://www.excelforum.com/member.php...o&userid=22006 View this thread: http://www.excelforum.com/showthread...hreadid=466641 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Combining Defined Names to New Name For Validation | Excel Worksheet Functions |