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

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

Thanks andy but no good.

I don't have admin rites to install.

It is just what I need but can't use.

Does anyone have the code?


"Andy Pope" wrote:

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

Not the code but you can do it manually.
http://www.andypope.info/tips/tip001.htm


Ian B wrote:
Thanks andy but no good.

I don't have admin rites to install.

It is just what I need but can't use.

Does anyone have the code?


"Andy Pope" wrote:


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


--

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

Ian B a écrit :

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



Hi Ian

Have à look there
http://cjoint.com/?jsue3kYagF
I think the macro "label" makes what you want.

cjoint.com is something like yousendit

HTH
--
François L