LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
mge mge is offline
external usenet poster
 
Posts: 8
Default Name to define a chart range

I am trying to use names to define the data and label ranges for my charts
but get an error message that my formula is incorrect. I have entered the
formula below and it works when not used in the chart tool. When I enter the
name in the chart tool I get an error message that my formula is incorrect.

I am using Excel 2007

CARLOW=OFFSET(SmallA!$B$119,0,0,'Calc Screen'!$Y$2,1)

--
mgelde
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to define a changing range for chart Rcarper Charts and Charting in Excel 2 January 14th 09 03:50 PM
Define a range jlclyde Excel Discussion (Misc queries) 2 April 17th 08 08:26 PM
Define chart range using indirect reference Thomas Charts and Charting in Excel 3 May 10th 06 09:44 PM
how to define range names anton New Users to Excel 1 October 14th 05 08:28 AM
Define a range based on another named range Basil Excel Worksheet Functions 2 February 21st 05 01:47 PM


All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"