adding Pie Chart option

Hi

What code is needed so as to add the option of a Pie Chart.In the userform I want to be able to choose between a Column Chart (code does this) and a Pie Chart.The Pie Chart would have the Labels on the outside of each section and the Pie Chart will have sizes in the code to adjust the size.Date will also be displayed underneath the Pie Chart

Thanks

hi,

i am not an expert in adding chart, i have done some alterations to your code and made the pie chart to work.

please check is it helpful to you.

Thanks

Hi,

Thank you...looks good

Terry