Chart updates on different worksheet as date changes

K

kvc

Hi,

Was just wondering..

We have 2 worksheets..

worksheet #2 as data with date field, item field, and device number
field.

worksheet #1, we built a vlookup so everytime someone enters a date,
the device number for that record displays.. is there also a way we
can build a pie chart to display that record as well in worksheet#1?

so everytime someone comes into that worksheet#1, they can see the
device number display and a pie chart for that record.

THANKS FOR ALL THE HELP!!
 
Top