change the data label of an chart to show qty

Hi and Thanks.

I have a chart showing the average price paid by each store for wellingtons.

some months there are 50 stores and other months 30 stores.

The question is I need a code that changes the data label to ='Price
Ave'!$C$1 for the first coloum & 'Price Ave'!$C$2 up to 'Price Ave'!$C$50

I need to write VB code show my chart shows each qty in the data label.

Hope that this makes sence.

The table data is in average price ascending. Called Price Ave Coloum (Qty
purchased) C

I'm not sure I understood your request, but does the attachment go close to what you want? (but I only did 11, not 50)

Originally Posted by Trever B

Hi and Thanks.

I have a chart showing the average price paid by each store for wellingtons.

some months there are 50 stores and other months 30 stores.

The question is I need a code that changes the data label to ='Price
Ave'!$C$1 for the first coloum & 'Price Ave'!$C$2 up to 'Price Ave'!$C$50

I need to write VB code show my chart shows each qty in the data label.

Hope that this makes sence.

The table data is in average price ascending. Called Price Ave Coloum (Qty
purchased) C

Thanks for that but my chart shows the average price not the qty.

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



"Bryan Hessey" wrote:

>
> I'm not sure I understood your request, but does the attachment go close
> to what you want? (but I only did 11, not 50)
>
>
> Trever B Wrote:
> > Hi and Thanks.
> >
> > I have a chart showing the average price paid by each store for
> > wellingtons.
> >
> > some months there are 50 stores and other months 30 stores.
> >
> > The question is I need a code that changes the data label to ='Price
> > Ave'!$C$1 for the first coloum & 'Price Ave'!$C$2 up to 'Price
> > Ave'!$C$50
> >
> > I need to write VB code show my chart shows each qty in the data
> > label.
> >
> > Hope that this makes sence.
> >
> > The table data is in average price ascending. Called Price Ave Coloum
> > (Qty
> > purchased) C
>
>
> +-------------------------------------------------------------------+
> |Filename: Chart2.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=3820 |
> +-------------------------------------------------------------------+
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=467424
>
>