Hi ALLDreams,

Here is a "non-elegant" solution:


Assume you have items "a", "b" and "c" in your first column (column 1)

1. Select all items (and dates and prices)
2. Create the chart you want
3. Select the entire area and apply autofilter.
4. Use a macro with the following code:

Dim SelectedItem as String
SelectedItem=Inputbox("Enter Item :")
'Error checks and validation
Selection.AutoFilter Field:=1, Criteria1:=SelectedItem


Your chart will automatically update for item you have entered.

Regards
Leni

--
Message posted from http://www.ExcelForum.com