Selecting data w/criteria and making chart.

My spreadsheet contains multiple entities with multiple rows of monthly data which I want to plot. I want to plot specific entities which are described by a unique number.

I would like for Excel to display a list of the entities in the spreadsheet and upon selection, it will make a chart of the monthly values vs. time for the selected entity. How can I display the entitities and, with subsequent selection of one of them, display the chart?

Thanks,

Jim

Jim

Pretty general, but maybe this will help.

A1:M1 - (headings) ID, Jul, Aug....Jun
A2:A5 - 1,2,3,4,5
B2:M6 - various numbers being your results

B14:M14 - Jul, Aug...Jun
A15: Data validation list with source: =$A$2:$A$6
B15: =INDEX(B1:B6,MATCH($A$15,$A$1:$A$6,0))
Copy across to M15

Graph range A14:M15

Make a selection change in A15 and the graph will update.

HTH

rylo