View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta
 
Posts: n/a
Default Label Doughnut-Chart outside

It's easy to simulate the effect.

Create the doughnut chart.

Now, add the same data set as a 2nd series.

Select one of the plotted series. Select Chart | Chart Type... | Pie chart

Double-click the pie chart and add the desired labels.

Position the labels as desired.

Double-click the pie chart and from the Patterns tab set 'Border' and
'Area' to None. If you have a legend, delete the extraneous entry from
there.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

Hi,

Does anyone has a VBA Script to label a doughnut chart outside the
actual chart with a leader line? Excel only gives you this option with
a pie chart.

Thanx for any help.

Steeplechase


--
Steeplechase
------------------------------------------------------------------------
Steeplechase's Profile:
http://www.excelforum.com/member.php...o&userid=31066
View this thread: http://www.excelforum.com/showthread...hreadid=507404