Chart using entity ID.

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. Attached is a sample data file.

I would like for Excel to display a list of the entities (entities described by Entity or API) 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 in the list and, with subsequent selection of one, display the chart?

Thanks,

Jim

Not sure that I've fully understood the question but maybe a pivot chart is what you are after. Look in Excel help for details.