On Wed, 22 Aug 2007, in microsoft.public.excel.charting,
That70sHeidi said:
Assigning the additional 'descriptor' values to my vendors doesnt really
link the data together, it just provides a way for me to sort and stare at
the data.

It looks as though you have sorting sorted, but you can't show just the
items you want. Have you looked at AutoFilter? That should let you
select one field by clicking on the value in that field, and the graph
should then show only what's filtered in (if you've got that option set
in Options)

Pivot Charts will also do some things, but you must be sure to have your
data sorted so that the fields are vertical columns with the field names
at the top in some distinctive format, (which it sounds like you've
already achieved if your sorting is good)

I can't seee your problem, which is a shame as you've framed your
question so well and comprehensively.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.