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