change the data label of an chart to show qty

[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

 

[Bryan Hessey]

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

Hi and Thanks.

I have a chart showing the average price paid by each store fo
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 'Pric
Ave'!$C$50

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

Hope that this makes sence.

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

+-------------------------------------------------------------------
|Filename: Chart2.zip
|Download: http://www.excelforum.com/attachment.php?postid=3820
+-------------------------------------------------------------------

 

[Trever B]

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