How about an alternative:

Apply data|filter|autofilter to your range
Create a single chart

But change the chart's properties to show just the data on the visible rows.
Select the chart and do:
Tools|Options|Chart Tab|check Plot visible cells only



gwhenning wrote:

I have a spreadsheet that is created from external data. I need to be able to
create a range for all cells matching certain criteria. Not all criteria will
occur every day, and there may be one or many cells containing the same
criteria. For example, Column A contains the Date, and column B contains the
part number. There may be one part number for a given day, or none. I need to
select all cells with part number 111, irregardless of date and create a
named range called 111. I will then create a graph for each named range in my
spreadsheet.

--

Dave Peterson