the items in my inventory. I list them horizontally, the
dates and prices for each item go in rows vertically.


-----Original Message-----
What do you mean by item?

--
__________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel


"ALLDREAMS" wrote
in message
...
Hi All,

In DATA! I keep historical prices of my inventory.
Items
are listed in Columm A, Date & Price are in Rows. I
recorded a macro to create a chart for one item.
However, I'd like to have a macro to prompt me for the
item and then create the chart. Could you help me with
this?

you help is greatly appreciated!


.