View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jaedend@charter.net is offline
external usenet poster
 
Posts: 1
Default Can I select a range based on the cell's contents?

Have want to make a pie chart of some data. The problem is that I do
not want to use every row, only certain rows based on the content of a
particular cell in that row. Is there a way to do this? When the
chart is asking for the data range, is there some type of formula I can
enter to select only those rows base on the contents of a cell in that
row?