Excel Pie Charts

[OzzieOwl]

Not totally sure if this is VBA, but here goes anyway.

I have some VBA that assigns values to a pre formatted Pie Chart in Excel, however the numbe of pieces of pie will vary from time to time. I have sorted out how to set the number of pieces of pie, but the positioning of the data labels moves everytime the pie chart is created, somtime pushing them off the top of the chart area. Does anyone have any idea how to stop/rectify this within VBA, or if possible within the formatting of the pie chart.

Thanks for any help

Ozzie

 

[SkipVought]

hi,

Please post some sample source data and describe what you want to see

Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]