View Single Post
 
Old 09-19-2017, 11:39 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

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 )
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote