View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean Dean is offline
external usenet poster
 
Posts: 93
Default Postioning of labels on charts using vba

I have an excel sheet that is populated from a database. The excel tables
that are populated act as data ranges for a chart. Now especially on a pie
chart we would like to see the data labels on each slice. However, not
knowing the values in advance leads to manual repositioning of the labels
especially for small values which often have to be placed outside the pie.

Can label positioning be done programatically per slice (or bar in a bar
chart) according to the value.

Thank you
--
Dean Mann