Can you bee a little more specific?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Lottie" wrote in message
...
I am trying to create a chart which looks up a value and then depending on
this value uses a certain set of data to draw the chart. I know it can be
done, as I have seen it, but I am not sure what I need to do