ExcelbyJoe – Learn Excel Dashboards and Functions

Learn to use Spreadsheets more effectively

How to Create Decision Wheel in Excel with VBA

Using VBA to create projects in Excel can be a lot of fun.  So I decided to build an Decision Wheel using a pie chart and visual Basic.

It wasn’t too hard to set up.  You just make a column of data for your chart numbers.  You want to make them relative to eachother.  For example, if you put 10,10,10,10,10 you will get 5 equal parts to your pie chart.  If you put 10,10,10,30,5, you will get one large part, 3 medium parts and one small.

Once you create your pie chart, you just have to make a macro to basically keep looping and changing the angle of the pie chart.

This video goes through the whole process and shows you step by step how to do it.

If you want to just buy the finished product, go to this link for the complete spreadsheet in Windows: https://www.etsy.com/listing/800679258/decision-wheel-in-excel-spreadsheet-in