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