Hi,

Here is a free addin you could use to label the pointsby linking the
data labels to cells.
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

Ian B wrote:
I need the label on top of each coloum to show qty not average eg:-

For eg
Store Ave Price Qty
Store A $50 100
Store B $40 500
Store C $60 10

Price
Ave

60 10
50 100 __
40 __ 500 __
30 __ __ __
20 __ __ __
10 __ __ __
0 __ __ __

Store A B C
Thanks

Hope you can help

I would like a macro or VB to loop throught code from 1st coloum to nth Coloum
to should qtyin label

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info