AJP Excel InformationAJP Excel Information
ChartsVBAFun stuffForumsTipsLinksBooksWhat's newContactAboutSearchRSS Feed

 
 
 

RE: Yes No count using named range

 
 
 
Named formula
ChtData:
=CHOOSE(ROW(Sheet1!$1:$2),COUNTIF(Sheet1!$A$2:$A$21,"Yes"),COUNTIF(Sheet1!$A$2:$A$21,"No"))
 
Chart Series formula
=SERIES(,{"Yes","No"},ng54.xls!ChtData,1)
Example file
   

Last updated 28th April 2007

 
 
  Home | Charts | VBA Code | Fun Stuff
Forum Examples | Tips | Links | What's New | Book List
Contact | About
Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2012 Andy Pope