| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change width of label box in pie chart | Charts and Charting in Excel | |||
| Possible to change chart title and label box widths? | Charts and Charting in Excel | |||
| Can you change the length of an excel chart data label? | Charts and Charting in Excel | |||
| How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
| Show data used and percent label | Charts and Charting in Excel | |||
Threaded Mode
