Variable / Conditional Address in Chart Data

		Microsoft Office Forums > Microsoft Excel > Excel
Variable / Conditional Address in Chart Data

FAQ

Thread Tools

Display Modes

02-06-2014, 09:52 PM

BobBridges BobBridges is offline

Windows 7 64bit Variable / Conditional Address in Chart Data

Office 2010 32bit

Expert

Join Date: May 2013

Location: USA

Posts: 700

I just tried the following formula in a test worksheet and it seemed to work:

Code:

=SUM(S119:OFFSET(S119,S124,0))

So apparently I can use a value in the range as one of the offsets. Guess that's not the problem.

I notice in your case your range runs across a single row rather than down a column. I suppose you meant it to be that way?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Project - variable data fields	pmarc	Word	7	04-04-2013 05:07 PM
Conditional Formatting over copied and pasted data	kb3264	Excel	6	07-11-2012 07:12 AM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM
How to create a chart with a variable width column?	Guy Roth	Excel	1	03-20-2012 05:52 AM
Inputting variable data	axy	Word	0	09-08-2009 04:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:29 AM.