Quote:
Originally Posted by Pecoflyer
Perhaps using a named range referring to
Code:
=INDEX($E3:$Z3,MATCH(9.99E+307,$E3:$Z3)-3):INDEX($E3:$Z3,MATCH(9.99E+307,$E3:$Z3))
Replace the 3 with any value or, better , with a cell reference. This will give you more flexibility[/code]Then use the named range as data source for your graph
( I hope I got the brackets right  ) |
Code:
=INDEX('Sales'!$M198:$HR198,MATCH(9.99E+307,'Sales'!$M198:$HR198)-30):INDEX('Sales'!$M198:$HR198,MATCH(9.99E+307,'Sales'!$M198:$HR198))
returns a #Value.... any assumptions?