Dynamic Stacked Column chart

Hi Chaps (and Ladies),

I would really appreciate some help creating what I believe will be a dynamic stacked column chart.

So if I have the following type of data setup in my worksheet:

Column A Column B
Angel 7
Fred 1
Angel 3
Fred 10
Fred 1
Angel 2

I would like to create a graph with one bar for Fred showing his min of 1, max of 10 and average of 4 and another bar for Angel showing a min of 2 max of 7 and average of 4.

Any ideas?

Thanks

Giles

Hi Giles,

please find attached an example file I created based on the info in your posted item.

I created a pivottableshowing the calculated data you want in your chart and then created a chart based on the pivot table...

hope it helps

J.