Hi,

You could try something as simple as putting the following in R1 and copying
down.

=IF(B1="ES",Q1,"")

Create your bar/column chart using columns B and R.
Obviously this will leave a gap in the chart, but than can be removed fairly
easily.
What do you want as your x-axis labels?

Dave

url:http://www.ureader.com/msg/10297252.aspx